Payment Report - Transactions (#217 & #310)
Payment Report - Transactions (#217 & #310)
This report lists all payments raised by each customer or supplier account.
Category
Enter the account category code to match, if applicable.
Account Code
Enter the account code to report on or leave blank for all.
Allocation
|
All |
= include all payments. |
|
Unallocated |
= include only payments that have not been allocated. |
|
Partial |
= include only payments that have been partially allocated. |
|
Fully Allocated |
= include only payments that have been fully allocated. |
Payment Type
|
All |
= include all payments. |
|
Pre-Payments only |
= include pre-payments/deposits only (customers only). |
|
Payment List |
= You may choose a specific transaction type to report on. The default is 6 - payment, however it is possible to add more via INSTALLATION Workshop. See the topic Transaction Sequences Setup for more information. |
Account Type
Specify a specific account type if applicable, such as regular, standard, internal, etc.
Bank Account
The applicable bank account to list for. Leave blank to include all bank accounts. This option is only applicable if the Cash Management system has been activated.
Daily Sub-total
Tick this option to include a daily sub-total of cheques issued.
List Allocations
Tick 
this option to list the transactions each payment allocated. Other useful information, such as the amount
of tax allocated, is also included.
When listing allocations the AMOUNT column shows the amount allocated by the payment, not the transaction's total. For example, if the transaction total was $100 but the payment (e.g., cheque) allocation was only $30, then $30 would be shown under this column.
The TAX PAID column shows the portion of allocated tax. For example, if the transaction total was $100 and the tax portion was $9.09, and the payment allocation was $30, then the tax paid would be $2.73. This is $30 divided by $100 = 0.3 * 9.09 = $2.727 (unrounded).
For important information on cash basis payment calculations see the topic: Cash Basis Versus Accrual Basis Accounting.
If you will be printing a report for a single account, payments assigned to, but not raised by that account,
will be excluded. For example, payments issued by another account such as a central billing (head office)
account, are not listed.
 |