Philippines Sales Journal
The Philippines Sales Journal includes information such as customer TIN (Tax Identification Number) and address details, amounts, and related invoice numbers. The following section are included in the audit files:
Sales Journal File Attribute Key
The File Attribute Key is a section of the Philippines audit files that lists the available columns and their descriptions. The following table lists the values that show in the File Attribute key section of the sales journal.
|
Field Name |
Description |
|---|---|
|
Date |
Displays the date of the transaction. |
|
Customer TIN |
Displays the tax registration number of the customer. |
|
Customer Name |
Displays the name of the customer. |
|
Address |
Displays the address of the customer. |
|
Description |
The value in this field is sourced from the Memo field. If the Memo field is blank, this is sourced from the Ref. No. field. |
|
Transaction Type |
Displays the transaction type. |
|
Reference / Doc No. / Invoice No. |
Displays the reference number of the document associated with the transaction. |
|
Amount |
Displays the gross amount. |
|
Discount |
Displays the total applied discount on the transaction. |
|
Net Sales |
Displays the net amount. |
|
VAT Amount |
Displays the tax amount. |
|
Gross Sales |
Displays the gross amount without the applied discount. |
Related Topics
- Philippines Tax Audit Files
- Prerequisites for Installing the Tax Audit Files SuiteApp
- Installing the Tax Audit Files SuiteApp
- Creating or Customizing Roles to Use Tax Audit Files
- Using Tax Audit Files
- Generating a Tax Audit File
- Adding Custom Fields to GL Data Extracts
- Troubleshooting Tax Audit File Generation Failures
- Downloading a Tax Audit File
- Deleting a Tax Audit File