Accounting

From the menu bar, choose Report > Accounting > Aged Debtors narrow ...OR... Aged Debtors wide.

The narrow version of the report is portrait orientation, the wide version is landscape.

This report will display the amount of unpaid invoices per customer, for the past 3 months from the specified tax date, and beyond. It will also show the amount of unallocated credit.

Sort By

What order should the results of the report be displayed in. ie. Alphabetically by customer name, or in numerical order of customer ID, or in order of total balance owing.

As At Tax Date

The amount owing will be calculated as at this date.

Include Later Payments

Should payments received after the date specified above, also affect the balance. (see below)

If you want a snapshot of how the accounts looked on the tax date you specify, you should choose No.

The aging and selection criteria is based on statement months, and these are relative to the month of the tax date the user specifies. The current month is the month that the specified tax date lies in.

This is not the number of months since the Invoice tax point, but the calendar month of the Invoice tax point. This is much more useful than other methodologies such as "30,60,90 days ago" because the aging reflects the way that most businesses in this trade submit their monthly statements or summary (monthly) invoices. No matter which day of the month you produce the report, the column for say, Prev Month, will accurately match the amount that the customer should have remitted for the statement or summary invoice of the month previous to the specified tax date.

If you choose to "Include Later Payments" when running the report, it will consider any payments received after the specified tax date.

Say he actually paid £199.75 via BACS on 05/06/15 (ie. 5 days after the tax date specified for the report)...

...if you choose to "Include Later Payments" but enter a tax date of 31/05/15 (ie. before the date he paid) then it will show his unpaid amount for the current month as £100.

...if you choose to not "Include Later Payments", but enter the tax date as 31/05/15 it will show his unpaid amount for the current month is £299.75.

So, if you need a historical snapshot of how debts looked on a particular month choose not to include later payments.

If you need to see a live representation of how the debtors look, choose to include later payments.

Unallocated credits represent payments, credit notes and adjustments that have affected the customer's balance, but Lab Manager has not been informed where to apply the credit. For example, if you've raised a credit note to cover an existing invoice Lab Manager needs to know that credit is for paying that invoice, otherwise it's left unallocated. Usually this process will be managed at the point the credit is added.

If you have unallocated credits you should check the customer's history for credits without a green tick beside them, then right click them and select Allocations. See Managing Your Debtors

Aged Debtors by Practice

This report will display the amount of unpaid invoices per customer, grouped by practice, for the past 3 months from the specified tax date, and beyond. It will also show the amount of unallocated credit.

Optional Practice ID or Tag	If you specify a practice account ID, or a tag name, the report will only show results for customers in that practice or practice with that tag. If you leave this blank, all practices will be included.
Sort By	Order the results alphabetically by name, or numerically by ID number.
New page per practice	Use NO to produce a continuous list of customers, or YES to show each practice on their own page.

If you have unallocated credits you should check the customer's history for credits without a green tick beside them, then right click them and select Allocations. See Managing Your Debtors

Audit Trail

This report lists all financial items between the dates you specify. Financial events include invoices, credit notes, payments, refunds etc.

First Date	The earliest date to show results for.
Last Date	The final date to show results for. All financial events between the first and last date will appear on the report.

Invoices in Period

First Date	The earliest date to show results for.
Last Date	The final date to show results for. All items between the first and last date will appear on the report.
Customer ID (optional)	If you specify a customer account number, the report will only show results for that customer, otherwise it will report for all customers.

List booked out uncharged

This will identify work you may have done in part and it has been booked out ongoing, but it has not been returned for subsequent stages.

Customer	Choose to report on all customers, the customer currently shown on the Main Form, or enter a customer ID.
Jobs older than (days)	Jobs older than this number of days will show on the report. To include all ongoing jobs either leave this box blank or use 0.
Sort by	Choose to order the list by the date the job was booked out ongoing, or by their due date.

Managers Financial Report

This report will summarise all financial activity between the specified dates. This includes payments and refunds, and invoice/credit note activity will be totalled by nominal category.

First Date	The earliest date to show results for.
Last Date	The final date to show results for. All items between the first and last date will appear on the report.

Nominal Account Summary

Provides a summary for each Nominal Account in the period, with sub-totals for each Account Type and a total Trial Balance.

First Date	The earliest date to show results for.
Last Date	The final date to show results for. All items between the first and last date will appear on the report.

Credits are shown as negative values when not explicitly labeled Credit (or CR).

As this report is using standard double-entry book keeping, the golden rule of accounting 'debit the receiver and credit the giver' applies.

This report lists payments grouped by Payment Method, with a Summary breakdown on the last page.

Customer	Choose to report for all customers, the current customer on the Main Form, or enter a customer account ID.
First Date	The earliest date to show results for.
Last Date	The final date to show results for. All items between the first and last date will appear on the report.

Reconciliation Report

The report shows a summary of your financial incomings and outgoings for the current financial year, current month and current day.

Financial Year (month)	The month in which your financial year begins.
Financial Year (day in month)	The day of the month that your financial year begins. Specify the month in the box above.

Summary Totals Report

First date	The earliest date to show results for.
Last date	The final date to show results for. All items between the first and last date will appear on the report.

Trial Balance

First date	The earliest date to show results for.
Last date	The final date to show results for. All items between the first and last date will appear on the report.

Accounting reports

Aged Debtors (narrow and wide)