How do I generate a supplier fast report with total balance at the bottom

AnnMarie · June 24

I need a year to date spend amount for a supplier. The fast report gives a list of all the transactions but no balance at the bottom of the report. I have filtered out the payments but cannot work out how to add the total at the bottom. Or is there a different report that can be run? I simply need to know how much we have spent with a couple of our suppliers this year.

It's probably very basic and easy but I cannot for the life of me work out how to add a balance to the bottom of the report.

Can anyone please help me?

Acctd4 · June 24

Hi @AnnMarie

Create your own from the Find:

Under the Edit dropdown menu, click on Find
On the Advanced tab, select the Date & choose your required Date/Dates range
Select the Name filter & choose the relevant Supplier (or even Multiple names to select several) you are wanting to report on
Under Transaction Type, select the relevant options (either a single type eg Bills or choose Multiple Transaction Types & tick all that apply (eg Bill, Bill Credit, Credit Card, Cheque etc)
Under Detail Level, select Summary only
Click on the Find button to generate the data, then on Report to display the results as a report.
In the report, click on the Modify Report button (top left) & filter/customise it further.

Here, on the Display tab, I have removed unnecessary columns, added, the ones I want, set Total by to Supplier & Sort by to Date, as well as giving it a Title:

Once you have the report exactly how you want it, click on the Memorise button (top left next to Modify …) it so it can be auto-generated from your Memorised Reports List ! :

Alternatively, you can also add it to your Icon Bar for simple 1-click access ! :

To add any report (or window) to your icon bar, simply display it on screen then click on the the report on

You'll see here, I have renamed it with a shorter label in order to prevent taking up too much space in the icon bar ! :

Now you - or your husband - can simply click on it to generate as needed & just tweak the template as required (eg for different Suppliers / Dates) 😊

Datarec · June 24

Hi @AnnMarie

You can try generating a FastReport for the "Accounts Payable" or "Trade Creditors" account from the Account List.

You can then modify that report and change the filters.

set the filter for a specific account, Name and Transaction Type

Kris_Williams · June 24

You could do an itemised Profit And Loss and then filter it and tick the names of the suppliers you need in Modify report

AnnMarie · June 24

Thank you Datarec. I did the report and it gives me the data but how do I get the balance to be just this financial year? I entered that parameter, however it gives me a starting balance from previous entries before that date.

Thank you Kris. I need to be able to show my husband how to generate this report, with the least number of steps. And as our company file is quite large, any itemised reports tend to take quite some time to generate and affects what the other users on other computers can do at the same time.

Is there no way to add a balance column to the Supplier Fast Report? Or just a balance total at the bottom of the Supplier Fast Report?

AnnMarie · June 25

Thank you Acctd4. That has enabled me to set up what he needs and show me how to do other reports.

Thank you everyone for your help.

As an aside - is there any way to add a total at the bottom of a fast report?

Kris_Williams · June 25

once you have the report you need memorise it, Ctrl M

How do I generate a supplier fast report with total balance at the bottom

Best Answer

Shaz Hughes Dip(Fin) ACQ NSW, MICB

* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

Accounted 4 Bookkeeping Services

Ballajura, WA

(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)

Answers

Categories