Providing elegant solutions to your Software Requirement.

Financial Report

Features of Filing Clerk
- Page 5

Financial Report
Introduced in version 1.2 of Filing Clerk, the Financial Report is a printed report that lists the documents’ date, type, title and the name of the company associated with the document, then its (invoiced) Net value, GST value, and applicable Net value.

The documents use User Defined Categories to group costs and income for your financial purposes.

User Defined Categories
To produce a financial reports.  Each document that represents an invoiced cost or income value must be assigned two user defined categories,  such as “Business Related” and “Consumables” .

These are  used together with the invoiced value and the GST value to provide the basic information for a profit and loss statement. (see right)

Take for example a telephone bill.  When this document is scanned, the Recognition Wizard (AI)  recognizes it as an “Invoice”, and the sourcing company name as “Telstra”, and because you have placed similar documents previously in the “Misc” Project/Folder, it  is also placed in the ”Misc” folder.

Finacial Report Page 1

Recognition Wizard
As each document is collected by Filing Clerk (by scanner or other means). The recognition wizard attempts to identify a dollar amount next to the word “total” and thus will generally identify the correct money value associated with an invoice, or receipt From this it calculates an appropriate amount of GST.  (See Example)

The wizard also identifies previous invoices from the same source (Telstra in our phone bill example) were given categories of “Home/Business” and “Phone” and suggests them for this document.* 

Generate a Financial Report
When all of your business documents have been identified in this manner, a financial report can be viewed and printed.  This report lists all of your cost items, as “Invoice Total”, “GST”, and “Applicable portion” with subtotals for each category. You have complete control over the names of the categories and groups of categories and over the applicable proportion of the amount involved. So for example, you can apportion (say) 35% of your computer consumable category to taxable income.

Don’t forget the income category, this category is used for all those documents that represent income and not costs.

Multiple Reports
By using the inbuilt filtering facilities, financial reports can be produced for specific time periods (financial year, per quarter, per month etc.) or for specific projects.  In total, filtering can be undertaken on any combination of fourteen different fields giving a very, very, large range of possible variations on the one report!

Non-financial documents
All those documents that do not represent a financial cost or income, or which are only a reminders of previously entered items, just assign a zero invoice cost, and they won’t appear in the report.

For our example document, the business cost will be located in the “Home/Business” group under the “Phone” heading, and as 50% of the category has been defined as taxable cost, 50% of the invoice value is listed in the “Applicable” column.

(see example).


* Usually the wizard works very well, but it needs to be checked to prevent mistakes.

The AI can be so stupid sometimes that it makes a goldfish look like Stephen Hawking.