Generating an Aged Debtors Report with Vat

1

Hi I am new to Manager, how do I generate an Aged Debtors (receivables) report that gives me net /vat and gross figures.

The standard Aged Receiveables report just gives me the total amount due but I need to calculate the vat amount for my year end.

Thanks

2

Show a sample (format)of such a report to make things clearer

3

Hi

Here is a sample of a report from our test company, it only gives a total gross amount.

My previous accounts package showed a column with the vat amount as well and you could calculate the net amount from there.

I can get a vat amount from Sales invoice listings when I click sales invoice lines but there is no option in the Aged Debtors report for this.

I have the same problem with purchases as both our purchases and sales have multiple vat rates, I can’t just calculate the vat amount from gross figure.

My only option now is to go through each invoice which makes up the total amount to get the vat figure.

Regards
Suzanne

(Attachment EWORC Manufacturing LTD 09.10.20 - Aged Receivables - As at 18-03-25.pdf is missing)

4

Screen Shot 2025-03-18 at 15.36.01.png
Screen Shot 2025-03-18 at 15.36.01.png5120×2880 147 KB

5

The amounts owed to your business and owed by your business include the VAT - why would you want to know the amounts excluding VAT?

6

For year end auditing we must show closing debtors/ creditor vat figures, this allows us to check we have paid our vat correctly during the year.

7

Ok, not sure what such a report will look like, sorry.

8

@suzannedelittle if you are seeking to check your VAT figures then you should try using the available tax reports.

image
image610×383 4.27 KB

9

Thanks Tony,

But those reports do not give me and end of year Debtor/Creditor figure as per the General Ledger.

I can use them to prepare and check my vat returns but not my end of year figures.

10

@suzannedelittle debtors and creditors reports do not show the VAT included in those figures but if you let me know how you intend to use the VAT figures in those reports, I might be able to suggest another option. Just in case you are intending to reconcile cash basis tax reports to accrual basis financial statements by allowing for the VAT included in debtors and creditors then that can be done in other ways.

11

Hi Tony,

I just need the closing Debtors and Creditors Vat amounts for my accountant for year end reports. The accountants then use these figures to ensure the vat control account.

Our vat returns are cash basis for sales and accrual basis for purchases, I am able to work with the system to check my returns each month.

But the only report that gives me the closing debtors and creditors balance does not show vat and we have several vat rates for purchases and two for our sales.

I have to go through each account and check all outstanding invoices to see what the vat rate is which is very time consuming.

I have never used an accounts package that does not allow a way to calculate the vat rate easily from a report or is already contained in the report.

Regards
Suzanne

12

The Tax reports give you the information needed to reconcile your Tax Account balances at your year-end

13

I’m not looking to balance the vat account. I am looking to provide our external accountant with the vat amount for our debtors and Creditors.

It is standard for me to provide these each year end for auditing purposes.

Thanks for your suggestions

14

@suzannedelittle unfortunately Manager does not provide the reports you require showing VAT. I am not used to taxes reported differently between accruals and cash basis for debtors and creditors.

15

The following workaround may yield the Sales/Debtor information you require - albeit a convoluted method.

  1. Run the ‘Taxable Sales per Customer’ report using ‘Accrual Basis’
  2. Run the same report using ‘Cash Basis’
  3. Subtract ‘Cash Basis’ amounts from ‘Accrual Basis’ amounts to give period end Tax payable.
  4. Compare to ‘Aged Receivables’ report balances.

If needed for Purchases/Creditors use the ‘Taxable Purchases per Supplier’ report.

Example:

image
image748×361 59.3 KB

image
image751×371 59.6 KB

Calculation using ‘Copy to clipboard’ into spreadsheet
image
image1268×297 18.9 KB

image
image762×257 43.4 KB

16

Thanks AJD,

I will give that a go, much appreciated.

Regards
Suzanne

17

Modify the Standard Aged Receivables Report

  1. Run the Standard Aged Receivables Report:
    Go to Reports > Aged Receivables to generate the default report showing total amounts owed by customers.
  2. Break Down VAT/Net Amounts:
    Since Manager does not natively split VAT and net in the Aged Receivables report, you’ll need to:
  • Export the Data: Export the report to Excel/CSV.
  • Calculate Net and VAT:
    • Use formulas to split the Gross Amount into Net and VAT based on your local VAT rate (e.g., Gross ÷ 1.2 = Net, Gross - Net = VAT for 20% VAT).
    • Group these values by aging buckets (30/60/90+ days).
18

Check the Sales and Purchases under tax they are vatable and i believe they can be of help to you, you cannot generate the Aged Debtors that is net of vat