Open topic with navigation

Analysis and Tax Details on a Journal

To enter analysis or tax details on a journal line in Classic EditionThe 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 mappingMapping of custom fields at header and line level for the purpose of profitability reporting. are displayed below the other analysis fields.)

In Extended EditionThe 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.

See the examples below for more information.

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 EditionThe 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

See Journal Fields for more information.

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

To create a journal that will generate a transaction with the same information as one derived from a payable invoice or credit note (VAT/GST):

Main Journal page

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

If you want to create a journal that will generate a transaction with the same information as a sales invoice or credit note (SUT):

Main Journal page

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

If you want to create a journal that will generate a transaction with the same information as a single line cash entry:

Main Journal page

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

If you want to create a tax journal to record some petty cash expenditure (VAT/GST):

Main Journal page

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

© Copyright 2009-2018 FinancialForce.com, inc. All rights reserved.
Various trademarks held by their respective owners.

Open topic with navigation