Build a Custom Report

Quick File make it easy to build your own customised reports. You can display your data in a variety of formats including line charts, bar charts and as a downloadable CSV file. Custom reports give you the freedom to display any information you like by referencing data in your nominal ledger, the backbone of your accounting system.

Getting Started!

To start building your first report you will need to navigate to the custom report area. From the dashboard click the menu link ‘Show All Reports’, then select the Custom Reports option.

In here you may find some useful reports that we have already prepared for you. In this case we will Click the button to create a new report.

First you will need to enter a name for the report and you can also enter a brief description.

Each report can have one or more series of data. A series is like a line of data on the graph and can represent a particular nominal account or a series of accounts.

When a new series is entered we will need a formula to pull out the right data. Your formula will reference a given nominal account by it’s unique account number. For example 4000 is the general sales account, entering “4000” into the formula box will simply display the transactions occurring on this account. You could also enter “4000:4010” this would display the total of all accounts between 4000 and 4010.
You will find a handy look-up tool to identify the correct nominal account number. Simply type the name of the account in the box and a list of matching accounts will instantly appear.

Here are a few more examples to get you started:

“4000 + 4001 + 4009”
This will show the sum of accounts 4000, 4001 and 4009.

“(4000:4010) - (5000:5999)”
This will show the sum of the range 4000 to 4010, minus the range 5000 to 5999.

“5000 * -1”
This will flip the polarity of the number therefore a balance of -20,000 becomes 20,000.

Once you have entered the series of information you would like the report to display then you are ready to save and preview.

We can now see our report displayed as a line chart. From here we can easily change the time period, the level of detail (e.g. days, weeks, months) and the preferred graph format.

That’s all there is too it! The custom reports tool gives you the freedom to quickly visualise a wealth of information within your accounts. You can build as many reports as you like and provide a quick access to your favourite reports from your dashboard.