Analysis and Tax Details on a Journal
To enter analysis or tax details on a journal line in Classic Edition The view of the application that you see when you first install the base managed package.., click the Analysis Details icon The Analysis Details dialog is displayed. If analysis details already exist, the icon will appear like this: . (Any custom fields that have been set up for sub-analysis mapping Mapping of custom fields at header and line level for the purpose of profitability reporting. are displayed below the other analysis fields.)
In Extended Edition The view of the application that you see when you install one of the extension packages (such as the Cash Entry Extension package). For invoices, credit notes, and journals Extended Edition is integrated into the main package, but must be configured., use the Analysis Details section on the Journal Line Items page. If you do not see this section, or the related tax total fields on the header, contact your administrator. They may need to add this section and the new fields to the appropriate page layouts.
For more information, see the below examples.
Rules
All line types
- If the owner company is VAT, you cannot enter anything into the Tax Value 2/3 or Tax Analysis 2/3 fields.
- Values in the Tax Value/Taxable Value fields must have the same sign as the line Amount.
- All tax values and taxable values are entered manually. There is no calculation of these amounts.
Account lines
- You can enter up to three tax values (these represent the tax included in the line amount, they are not mandatory fields).
- You cannot enter an amount in the taxable value field.
- You cannot enter an account in the account analysis field.
- You cannot enter anything into the product analysis field.
- You cannot enter anything into the tax analysis fields.
Product lines
- You can enter up to three tax values (these represent the tax included in the line amount, they are not mandatory fields).
- You cannot enter an amount in the taxable value field.
- You cannot enter a product in the product analysis field.
GLA lines and Bank Account lines
- You can enter up to three tax values (these represent the tax included in the line amount, they are not mandatory fields).
- You cannot enter anything in the taxable value field.
Tax lines
- You must enter the taxable value (this represents the taxable value for the line amount, it is a mandatory field).
- You cannot enter an amount in any of the three tax value fields.
- You cannot enter a tax code in any of the three tax analysis fields.
- You cannot enter anything into the product analysis field.
Bank lines
- You cannot enter anything in the tax value fields.
- You cannot enter anything in the tax analysis fields.
- You cannot enter anything in the product analysis field.
Intercompany
- You cannot enter anything in the tax value fields.
- You cannot enter anything in the taxable value field.
- You cannot enter anything in the tax analysis field.
- You can enter a value in the account and product analysis fields. Any values entered will be passed to the destination company along with the GLA for that line.
Tax Analysis
The Tax Analysis section on the journal header enables you to see one or more tax totals and a taxable value total. These fields are read-only and are automatically updated.
If you do not see this section in Extended Edition The view of the application that you see when you install one of the extension packages (such as the Cash Entry Extension package). For invoices, credit notes, and journals Extended Edition is integrated into the main package, but must be configured., contact your administrator. They will need to add these fields to the appropriate page layout.
The Tax Analysis section varies according to your tax regime.
In a Value Added Tax (VAT) organization, you see two fields:
- Tax Total
- Taxable Value Total
For more information, see Journal Fields.
In a Sales and Use Tax (SUT) organization, you initially see the Tax Total field with an adjacent link that enables you to view more details. Click the link to display the Tax Totals Detail panel.
Examples
Main Journal page
Line Type | Item | GLA | Amount | Line Description |
---|---|---|---|---|
Account-Vendor | Eversafe | 2000-AP Control | –655.00 | |
Product-Purchases | 2GB RAM | 5300-COGS | 500.00 | |
GLA | 5300-COGS-Delivery | 50.00 | ||
Tax | VI-S | 2190-VAT Input | 100.00 | VI-S |
Tax | VI-R | 2190-VAT Input | 5.00 | VI-R |
Analysis Details dialog
Tax Value | Tax Value 2 | Tax Value 3 | Taxable Value | Tax Analysis | Tax Analysis 2 | Tax Analysis 3 | Account Analysis | Product Analysis | Expense Analysis |
---|---|---|---|---|---|---|---|---|---|
–105.00 | Eversafe | ||||||||
100.00 | VI-S | Eversafe | 2GB RAM | ||||||
5.00 | VI-R | Eversafe | 5400-COGS-Delivery | ||||||
500.00 | Eversafe | ||||||||
50.00 | Eversafe |
Main Journal page
Line Type | Item | GLA | Amount | Line Description |
---|---|---|---|---|
Account-Customer | Sunnyview | 1200-AR Control | 347.40 | |
Product-Sales | 8GB RAM | 4100-Sales | –320.00 | |
Tax | STATE-CA | 2160-Sales Tax | –26.40 | STATE-CA |
Tax | COUNTY-SF | 2160-Sales Tax | –0.80 | COUNTY-SF |
Tax | CITY-SF | 2160-Sales Tax | –0.20 | CITY-SF |
Analysis Details dialog
Tax Value | Tax Value 2 | Tax Value 3 | Taxable Value | Tax Analysis | Tax Analysis 2 | Tax Analysis 3 | Account Analysis | Product Analysis | Expense Analysis |
---|---|---|---|---|---|---|---|---|---|
26.40 | 0.80 | 0.20 | Sunnyview | ||||||
–26.40 | –0.80 | –0.20 | VI-S | Sunnyview | 8GB RAM | ||||
–320.00 | STATE-CA | Sunnyview | |||||||
–320.00 | COUNTY-SF | Sunnyview | |||||||
–320.00 | CITY-SF | Sunnyview |
Main Journal page
Line Type | Item | GLA | Amount | Line Description |
---|---|---|---|---|
Account-Customer | Sunnyview | 1200-AR Control | –500.00 | |
Bank Account | Barclays | 2200-Bank | 500.00 |
Analysis Details dialog
Tax Value | Tax Value 2 | Tax Value 3 | Taxable Value | Tax Analysis | Tax Analysis 2 | Tax Analysis 3 | Account Analysis | Product Analysis | Expense Analysis |
---|---|---|---|---|---|---|---|---|---|
Sunnyview | |||||||||
Sunnyview |
Main Journal page
Line Type | Item | GLA | Amount | Line Description |
---|---|---|---|---|
GLA | 2300-Petty Cash | –30.50 | ||
GLA | 7100-Stationery | 20.00 | Envelopes | |
GLA | 7200-Stamps | 6.50 | Fist Class Stamps | |
Tax | VI-S | 2190-VAT Input | 4.00 | VI-S |
Tax | VI-E | 2190-VAT Input | 0.00 | VI-E |
Analysis Details dialog
Tax Value | Tax Value 2 | Tax Value 3 | Taxable Value | Tax Analysis | Tax Analysis 2 | Tax Analysis 3 | Account Analysis | Product Analysis | Expense Analysis |
---|---|---|---|---|---|---|---|---|---|
4.00 | VI-S | ||||||||
0.00 | VI-E | ||||||||
20.00 | VI-S | ||||||||
6.50 | VI-E |
Key:
Disabled or validated out according to line type |