
p92
Big Red Book Accounts v5
Purchase Ledger Reports
There are a number of reports relating to the Purchase Ledger and the purpose and content of each will be
described below.
The Purchase Ledger Reports menu
Ledger Accounts
This report displays all transactions for specified Suppliers for a specified period. The format of the report is
very similar to the
Lookup - Suppliers
option. It differs in that the report can be produced for more than one
Supplier and it can be produced for a particular period (rather than for the whole Financial Year).
Its most common uses are: to verify the correctness of Suppliers’ statements that you receive, and to
produce for your accountant full details of Supplier Accounts at year end. It is particularly useful for
comparing to Suppliers’ statements because its format is very similar to that used by most Suppliers.
Aged Creditors
This report lists the amount owing to each Supplier as of the end of a specified month and provides an aged
analysis of the balance on each account. You can choose to exclude Suppliers with a zero balance as of the
month specified.
You can select the Period up to which transactions should be included. Transactions will be included based
on the Period and not the transaction date. Negative balances are always applied progressively from the
oldest eg. if a supplier owed you money from 3 months ago and there were no other transactions it would
appear as a 'Current' balance.
Calculating Aged Balances with Allocations Off:
Invoices
The transaction date determines its age as either Current, 1 Month old, 2 Months or 2 Months+;
Payments
Applied so as to reduce the oldest balance first.
Credit Notes
and
Journals
These will be treated either Invoices or Payments depending on which option you chose in
Setup/Options
Calculating Aged Balances with Allocations On:
Balances are calculated based on the outstanding balance of invoices only on the date being aged to.
Unallocated payments are shown separately.
Creditors Listing
This report lists the amount owing to each Supplier as of the end of a specified month. It also shows the
turnover with each Supplier (i.e. the total of all invoices less credit notes received from that Supplier in the
Financial Year-to-Date). You can choose to exclude Suppliers with a zero balance as of the month specified
in the report.
You can choose to exclude Suppliers with a zero balance as of the month specified.
Creditors Control
This report provides a summary, for a specified period, of all the activity between your business and your
Suppliers/Creditors. It shows summary totals for all purchase invoices (net of credit notes), payments made,
discounts received and adjustments made to accounts through Journal entries. It is useful in providing a
quick overview of aggregate totals for Purchase Ledger (i.e. Creditors) activity. The figures displayed on this
report are calculated as follows:
Comentários a estes Manuais