Appendix A: Examples of Transaction Postings
Introduction
This Appendix is intended to shown the account impact of transactions entered and posted in Accounts Payable. The “T” charts show the debits (DR) and credits (CR) to General Ledger accounts for a number of typical transactions. The values of pertinent fields are also shown for each example.
Prorating Freight, Tax, and Other
Freight, Tax, and Other amounts may be entered for each invoice. These amounts are summed and prorated over each line item of the invoice that has a “Y” value for the Pro-rate? flag. The formula to determine the amount of proration for each line item is:
Proration Amount = line item amount * (freight + tax + other) invoice subtotal
This proration amount is then added to the line item amount to determine the line item total. Thus,
Line Item Total = line item amount + proration amount
This example assumes the receipt of an invoice for $200.00 of Office Supplies and $800.00 of Office Equipment. Sales Tax totaling $70.00 and Freight for $30.00 are also on the invoice.
Invoice Amount: $1100.00 Freight: $30.00 Subtotal: $1000.00 Tax: $70.00 Other: $00.00
Invoice Post
If the Prorate? flag is “Y” for both invoice line items, the transaction posts as follows:
| DR | CR |
|---|---|
| 1100.00 | |
| DR | CR |
|---|---|
| 220.00 | |
| DR | CR |
|---|---|
| 880.00 | |
If no freight or tax is prorated to the Office Equipment Expense line item, change the Prorate? flag to “N” during line item entry. Then, the invoice posts with the total of the freight and tax amounts added to the Office Supplies amount as follows:
| DR | CR |
|---|---|
| 1100.00 | |
| DR | CR |
|---|---|
| 300.00 | |
| DR | CR |
|---|---|
| 800.00 | |
If Freight, Tax, and Other charges are not prorated over at least one of the invoice line items, they may be directly expensed by identifying them as separate line items. Thus, the Freight and Tax are not included fin the cost of the Office Supplies and Office Equipment but are attributed to their own expense accounts.
Invoice Amount: $1100.00 Freight: $00.00 Subtotal: $1100.00 Tax: $00.00 Other: $00.00
Invoice Post
| DR | CR |
|---|---|
| 1100.00 | |
| DR | CR |
|---|---|
| 200.00 | |
| DR | CR |
|---|---|
| 800.00 | |
| DR | CR |
|---|---|
| 30.00 | |
| DR | CR |
|---|---|
| 70.00 | |
Appendix A: Examples of Transaction Postings