Overview
Accounting Seed supports two methods of posting Billings and Payables: Header Level Posting (HLP) and Line Level Posting (LLP). There are significant advantages to adopting HLP, which includes the following:
- The reduction of data usage
- The reduction of clutter in the AR Control GL Account
- The ability to include Billing Line Level tax calculations by using a Tax Group. For more information, refer to the Set up AS Native Tax article.
With Billing LLP, once a Billing is posted, the Billing Line record creates a pair of transactions for each Billing Line:
- The debit entry will always be to the Accounts Receivable GL Account that is set in Accounting Settings
- The credit entry is made to the GL Account that is set in the Revenue GL Account field on the Billing Line.
Each Billing Line will repeatedly post to the AR Control GL Account. This can result in an inefficient number of debit transactions created to the AR Control GL Account. Additionally, there will be numerous debit transactions from each line cluttering your AR Control GL Account. For example, with Billing LLP, if you have a Billing with 500 lines, this will result in 1,000 transactions to the General Ledger, of which 500 will post to Accounts Receivable. Under Billing HLP, you would have 501 transactions to the General Ledger, of which only one transaction will be posted to Accounts Receivable.
Under Billing HLP, the debit to the AR Control GL Account does not inherit any of the Billing Line dimension characteristics, i.e., the GL Variable 1-4, Product, Project, Project Task, or the Time Card Variable 1-2. As a result, the GL Variable 1-4 filters will not display on the following Accounting Seed Financial Reporter statements:
- Balance Sheet
- Trial Balance
- Cash Flow Statement.
The filters will not display because these reports include the AR Control GL Account and you cannot filter by GL Variable 1-4 since none of the debits to this GL Account have this information.
Note: To create GL Variable 1-4 filtered reports on Financial Statements, use the Custom Reporter, but note that this same limitation applies.
For industries such as, “Not For Profits” that need to segment Balance Sheet accounts by dimension (i.e., GL Variable 1-4), Billing LLP would be a more suitable option.
With Billing HLP, the number of posted transactions for Billings can be reduced in the following two ways:
- Consolidating debit transactions - Only one debit transaction to the AR Control GL Account will be posted for all of the Billing Lines that are associated with a Billing record.
- Consolidating credit transactions - A credit transaction is created for each unique combination of the following dimensions:
-- Revenue GL Account
-- GL Variable 1-4
-- Product
-- Project
-- Project Task
-- Time Card Variable 1-2.
Note: Billing HLP is supported for Multi-Currency users.
Note: For users of Accounting Seed’s Orders and Inventory module, Billing HLP is available to be used with the Weighted-Average Cost system. It is not available if you are using the Standard Cost version of the Orders and Inventory module. If you wish to migrate, please contact Customer Support.
Do you want to view one of the following:
- Sample Billing Record without a Tax Amount
- Sample Billing Record - Accounting Transactions without a Tax Amount
- Sample Tax Group and Tax Rate Information
- Sample Billing Record with a Tax Amount
- Sample Billing Record - Accounting Transactions with a Tax Amount
Sample Billing Record without a Tax Amount
Billing Record: 0005 | ||||||||||||
Billing Line | Product | Revenue GL Account | Qty | Unit Price | Sub-total | Tax Group | Tax Amount | Total | GLAV 1-4 | Project | Project Task | TCV 1-2 |
BL-1000 | Control Panel | 4000-Product Revenue | 1.00 | $100.00 | $100.00 | --- | --- | $100.00 | --- | --- | --- | --- |
BL-1001 | Control Panel | 4000-Product Revenue | 1.00 | $200.00 | $200.00 | --- | --- | $200.00 | --- | --- | --- | --- |
BL-1002 | Control Panel | 4000-Product Revenue | 3.00 | $150.00 | $450.00 | --- | --- | $450.00 | Dept A | --- | --- | --- |
BL-1003 | Control Panel | 4000-Product Revenue | 4.00 | $150.00 | $600.00 | --- | --- | $600.00 | Dept A | --- | --- | --- |
Sample Billing Record - Accounting Transaction without a Tax Amount
Based upon the Sample Billing record above, with Billing HLP, only three transactions will be posted to the GL. There will be one transaction to the debit AR Control GL Account, which is the total of $1,350.00.
$100.00 + $200.00 + $450.00 + $600.00 = $1,350.00 (total amount)
Accounting Transactions | |||||||||
TRN | Product | GL Account | Qty | Amount | GLAV 1-4 | Project | Project Task | Account | Billing |
TRN - 01 | --- | 1200-AR Control GL Account | 1,350.00 | --- | --- | --- | Alpha Comm | 0005 |
For the credit side of the entry, the Revenue GL Account is the same for all four of the Billing Lines. However, there are some differences in the GLAV 1-4 dimension. On the first two Billing Lines, no department is listed. But, on the last two Billing Lines, Department A is listed. Therefore, two credit transactions will be posted based upon the two unique dimension combinations.
Revenue GL Account = 4000-Product Revenue
GLAV 1-4 = No department specified, with a total amount of $300.00
Revenue GL Account = 4000-Product Revenue
GLAV 1-4 = Department A, with a total amount of $1,050.00
Accounting Transactions | |||||||||
TRN | Product | Revenue GL Account | Qty | Amount | GLAV 1-4 | Project | Project Task | Account | Billing |
TRN - 02 | Control Panel | 4000-Product Revenue | 2.00 | (300.00) | --- | --- | --- | Alpha Comm | 0005 |
TRN - 03 | Control Panel | 4000-Product Revenue | 7.00 | (1,050.00) | Dept A | --- | --- | Alpha Comm | 0005 |
Note: Click here to view the above image in full screen.
Sample Tax Group and Tax Rate Information
Tax Rate Name | Tax Type | Tax Rate GL Accounts | Tax Group A | Tax Group B | |
Purchase Tax Expense GL Account |
Sales Tax Liability GL Account | ||||
Tax Rate 1 | Sales | 2500-DC Tax Liability | 5.000% | ||
Tax Rate 2 | Sales | 2500-DC Tax Liability | 2.000% | ||
Tax Rate 3 | Sales | 2501-MD Tax Liability | 3.000% | ||
Tax Rate 4 | Sales | 2501-MD Tax Liability | 1.000% | ||
Tax Rate 5 | Sales | 2501-MD Tax Liability | 2.000% | ||
Tax Rate 6 | Sales & Purchases | 6000-Tax Expense | 2501-MD Tax Liability | 3.000% | |
Tax Rate 7 | Sales & Purchases | 6000-Tax Expense | 2501-MD Tax Liability | 1.000% | |
Combined Tax Rate | 13.000% | 4.000% |
The Combined Tax Rate for Tax Group A includes all of the rate percentages that are in Tax Rates 1-5 (5.000% + 2.000% + 3.000% + 1.000% + 2.000% = 13.000%). The Combined Tax Rate for Tax Group B consists of the two percentage rates that are in Tax Rate 6 and 7 (3.000% + 1.000% = 4.000%).
Sample Billing Record with a Tax Amount
Billing Record: 0005 | ||||||||||||
Billing Line | Product | Revenue GL Account | Qty | Unit Price | Sub-total | Tax Group | Tax Amount | Total | GLAV 1-4 | Project | Project Task | TCV 1-2 |
BL-1000 | Control Panel | 4000-Product Revenue | 1.00 | $100.00 | $100.00 | Grp A | $13.00 | $113.00 | --- | --- | --- | --- |
BL-1001 | Control Panel | 4000-Product Revenue | 1.00 | $200.00 | $200.00 | Grp B | $8.00 | $208.00 | --- | --- | --- | --- |
BL-1002 | Control Panel | 4000-Product Revenue | 3.00 | $150.00 | $450.00 | Grp B | $18.00 | $468.00 | Dept A | --- | --- | --- |
BL-1003 | Control Panel | 4000-Product Revenue | 4.00 | $150.00 | $600.00 | Grp B | $24.00 | $624.00 | Dept A | --- | --- | --- |
Sample Billing Record - Accounting Transactions with Tax Amount
Based upon the Sample Billing record above, with Billing HLP, there will be one transaction to the debit AR Control GL Account, which is the total of $1,413.00.
$100.00 + $200.00 + $450.00 + $600.00 = $1,350.00 (subtotal amount) + $63.00 (tax amount) = $1,413.00
Accounting Transactions | |||||||||
TRN | Product | GL Account | Qty | Amount | GLAV 1-4 | Project | Project Task | Account | Billing |
TRN - 01 | --- | 1200-AR Control GL Account | 1,413.00 | --- | --- | --- | Alpha Comm | 0005 |
For the credit side of the entry, the Revenue GL Account is the same for all four of the Billing Lines. However, there are some differences in the GLAV 1-4 dimension. On the first two Billing Lines, no department is listed. But, on the last two Billing Lines, Department A is listed. Therefore, two credit transactions will be posted based upon the two unique dimension combinations.
Revenue GL Account = 4000-Product Revenue
GLAV 1-4 = No department specified, with a total amount of $300.00
Revenue GL Account = 4000-Product Revenue
GLAV 1-4 = Department A, with a total amount of $1,050.00
Accounting Transactions | |||||||||
TRN | Product | Revenue GL Account | Qty | Amount | GLAV 1-4 | Project | Project Task | Account | Billing |
TRN - 02 | Control Panel | 4000-Product Revenue | 2.00 | (300.00) | --- | --- | --- | Alpha Comm | 0005 |
TRN - 03 | Control Panel | 4000-Product Revenue | 7.00 | (1,050.00) | Dept A | --- | --- | Alpha Comm | 0005 |
For the tax amount, Billing Line 1000 is in Tax Group A, which includes two different Sales Tax Liability GL Accounts. Refer to the Sample Tax Group and Tax Information table. Billing Line 1001 is in Tax Group B, which has the same MD Sales Tax Liability GL Account as Tax Rates 3-5 under Tax Group A. Therefore, the Tax Group B portion of these two Billing Lines (BL 1000 and BL 1001) can be combined into one transaction. The credit transactions for sales tax will require three separate transactions.
Sales Tax Liability = 2500-DC Tax Liability
GLAV 1-4 = None
Tax Group A - Tax Rate 1, 5.00% + Tax Rate 2, 2.00% = 7.00%
$100.00 X 7.00% = $7.00
Sales Tax Liability = 2501-MD Tax Liability
GLAV 1-4 = None
- Tax Group A - Tax Rate 3, 3.00% + Tax Rate 4, 1.00% + Tax Rate 5, 2.00% = 6.00%
$100.00 X 6.00% = $6.00 - Tax Group B - Tax Rate 6, 3.00% + Tax Rate 7, 1.00% = 4.00%
$200.00 X 4.00% = $8.00
Sales Tax Liability = 2501-MD Tax Liability
GLAV 1-4 = Department A
Tax Group B - Tax Rate 6, 3.00% + Tax Rate 7, 1.00% = 4.00%
$1050.00 X 4.00% = $42.00
Accounting Transactions | |||||||||
TRN | Product | Revenue GL Account | Qty | Amount | GLAV 1-4 | Project | Project Task | Account | Billing |
TRN - 04 | 2500-DC Tax Liability | (7.00) | --- | --- | --- | Alpha Comm | 0005 | ||
TRN - 05 | 2501-MD Tax Liability | (14.00) | --- | --- | --- | Alpha Comm | 0005 | ||
TRN - 06 | 2501-MD Tax Liability |
(42.00) |
Dept A | --- | --- | Alpha Comm | 0005 |
Note: Click here to view the above image in full screen.
Return to top
When Billing Header Level Posting is enabled, keep the following points in mind:
- The credit transaction(s) consolidates any Billing Line that has the same dimensions, including the following:
-- Revenue GL Account
-- Product
-- Project
-- Project Task
-- GL Variable 1-4
-- Time Card Variable 1-2. - The debit AR Control GL Account will NOT include a sum of the Billing Line Quantity. The credit to the Billing Lines will include the sum of the Billing Line Quantity.
Comments
0 comments
Please sign in to leave a comment.