Creditors Reports

You can use the Excel icon to produce reports directly to Excel. Permission for use of this is based on security since it accesses the report for the information.

When Excel is selected, it will open spreadsheet windows and populate it with raw data from the selected report. Each report pipeline with be represented in a separate sheet, eg. Job, JobComments, JobStock etc. This will produce a much more comprehensive report in spreadsheet format for all these reports.

1.Go to Accounts > Creditors, and run the Creditors list.

2.Enter the Date Due < > dates required to run the aged payables for.

3.Select the Aged Payables Detailed report in the Report section of the ribbon.

4.From there, click either Print or Preview on the ribbon.

Note: If Multi-currency is in use, there will be no grand total at the bottom as it would show mixed currency types, resulting in inaccurate grand totals.

Selecting the Aged Payables Summary report will show a summary of payables for each creditor in the list. This report will show a grand total in home currency for multi-currency reports.

See here for detailed information on the Taxable Payment Annual Report.

The following reports are available to choose from:

Report	Explanation
Cheque	Print a cheque on a preprinted cheque form:
Cheque Remittance	This will produce a cheque remittance advice for emailing/printing. Choose from either a cheque number or a payment number, which may include numerous invoices in the payment.     Tick to include any related credit allocations. this will show any adjustments that have been applied to payments.
Credit Allocation	Produce a report showing the credit allocations for payments:     Using the Excel icon will produce a much more comprehensive report in spreadsheet format.
Creditors Reconciliation	Choose the dates from and to. This report can be saved in a spreadsheet format for reviewing.
EFT Remittance v2	This will produce an EFT remittance advice for emailing/printing. Choose from either a cheque number or a payment number, which may include numerous invoices in the payment.
Transaction History	Choose a date range to produce a transaction history that can be printed/emailed.