The Reports tab has a number of Transaction list template reports available to print. There are two Report Templates for Accounts Payable and Accounts Payable Ledger reports, each with their own set of reports and options.
Accounts Payable
Select Aging Date – Choose a date to be used for determining how old each transaction is and which aging amount column will be accumulated by each transaction.
Show Details – Enable this option to print Contact information and a list of open transactions and their respective aged amount for each vendor. Disable this option to print a single line for each vendor and total amounts for each aging period.
Vendor No – Either select a specific vendor to print this report for, or leave this blank to print all vendors with an accounts payable balance outstanding.
Accounts Payable Grouped by Due Date – Prints a list of outstanding vendor transactions, grouped by due date and sorted with oldest transactions at the top. Overdue transactions display the due date in red font.
Aged Accounts Payable List – Prints a list of vendors and their respective transaction totals in columns aged by transaction date, grouped by currency, calculated from open and historical transactions as of the report date. Transactions with a date after the aging date are excluded from the report. If Details are shown, contact info and individual transactions are also printed.
Aged Accounts Payable List by Due Date – Prints a list of vendors and their respective transaction totals in columns aged by due date, grouped by currency, calculated from open and historical transactions as of the report date. Transactions with a due date after the aging date are excluded from the report. If Details are shown, contact info and individual transactions are also printed.
Historical Accounts Payable List – Prints a list of vendors and their respective transaction totals in columns aged by transaction date, grouped by currency, calculated from open and historical transactions as of the report date. Transactions with a date after the aging date are excluded from the report, as are applications of payments to invoices performed after the report date. If Details are shown, contact info and individual transactions are also printed. Results will be the same as the Accounts Payable List report, if no transactions were backdated when posted.
Accounts Payable Ledger
Start Date / End Date – Choose a date range to include transactions for the report.
Show Details – Enable this option to print Contact information and a list of open transactions and their respective amounts for each vendor. Disable this option to print a single line for each vendor and total amounts.
Vendor No – Either select a specific vendor to print this report for, or leave this blank to print all vendors with an accounts payable balance outstanding.
Currency – Either select a specific currency to print this report for associated vendors, or leave this blank to print all vendors with an accounts payable balance outstanding, grouped by currency.
Sort Order – Choose to print vendors sorted by either Vendor Code or Vendor Name.
1099-MISC 1-UP Preprinted – Prints the 1099-MISC form contents for US vendors, for use with pre-printed forms that have one vendor per page. Only vendors with USD currency will be selected.
1099-MISC 2-UP Preprinted – Prints the 1099-MISC form contents for US vendors, for use with pre-printed forms that have two vendors per page. Only vendors with USD currency will be selected.
1099-NEC 1-UP Preprinted – Prints the 1099-NEC form contents for US vendors, for use with pre-printed forms that have one vendor per page. Only vendors with USD currency will be selected.
1099-NEC 2-UP Preprinted – Prints the 1099-NEC form contents for US vendors, for use with pre-printed forms that have two vendors per page. Only vendors with USD currency will be selected.
1099-NEC 3-UP Preprinted – Prints the 1099-NEC form contents for US vendors, for use with pre-printed forms that have three vendors per page. Only vendors with USD currency will be selected.
CPRS-T5018 IRS-1099 List – Prints a list of vendors that have either 1099 or T5018 as a Report Type, and transactions within the report date range. Invoice and Payment totals in Base currency and the billing address print for each vendor, grouped by 1099 or T5018. If Details are shown, individual transactions are also printed.
Disbursements Journal – Prints a list of payments within the selected date range, sorted by date, and for the specified vendor if one was chosen. If Details are shown, paid invoices are also printed with each payment. If multiple currencies are printed, then vendors for each currency are grouped separately, and the report grand total is hidden.
Vendor Transaction Activity – Prints a list of transactions within the selected date range, grouped by vendor and currency. If Details are shown, applied transactions are also printed.
