Accounting reports |
Top Previous Next |
Aged Debtors (narrow and wide)
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.
Parameters
Example
How to interpret this report
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.
For example: Surgeon J, Blunt owed £299.75 in the current month as at 31/05/15. 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
From the menu bar, choose Report > Accounting > 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. This report is only available in portrait orientation.
Parameters
Example
How to interpret this report
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.
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
Audit Trail
From the menu bar, choose Report > Accounting > Audit Trail.
This report lists all financial items between the dates you specify. Financial events include invoices, credit notes, payments, refunds etc. Totals will be shown on the final page.
Parameters
Example
Invoices in Period
From the menu bar, choose Report > Accounting > Invoices In Period
This report lists all invoices and credit notes between the dates you specify. Totals appear on the final page of the report.
Parameters
Example
List booked out uncharged
From the Menu bar, choose Report > Accounting > 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.
Parameters
Example
Managers Financial Report
From the Menu bar, choose Report > Accounting > Manager's 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.
Parameters
Example
Nominal Account Summary
From the Menu bar, choose Report > Accounting > 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.
Parameters
Example
How to interpret this 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.
Also see Understanding Double-entry Bookkeeping
From the Menu bar, choose Report > Accounting > Payments.
This report lists payments grouped by Payment Method, with a Summary breakdown on the last page.
Parameters
Example
Reconciliation Report
From the Menu bar, choose Report > Accounting > Reconciliation Report.
The report shows a summary of your financial incomings and outgoings for the current financial year, current month and current day.
Parameters
Example
Summary Totals Report
From the Menu bar, choose Report > Accounting > Nominal Account Summary
Provides a summary for each transaction type in the period
Parameters
Example
Trial Balance
From the Menu bar, choose Report > Accounting > Trial Balance
A summary of your debits and credits for the specified period.
Parameters
Example
|