Business Pack Reports
NOTE: Report and Export facilities apply whether Business Codes are activated or not. Some reports and export fields will not be available unless activated.
Saved Presets
All report settings can be saved for later use. To reuse a previous configuration simply select the appropriate Preset from the drop-down menu and specify the required date range.
Report Types
All categorised
Reports all transactions (both imported and journals (manually entered transactions) that are fully named and categorised.
All uncategorised
Designed to show all transactions that have not been categorised and/or not named.
Selected categories
Reports all categorised transactions within general categories and account ranges e.g. Income, Expenses…
Imported as statement
Shows the bank statement side of all imported transactions. Since job and extended codes do not apply to these records they are not reported - even if specified in the list of fields to export. All records are reported irrespective of whether they are named or allocated / categorised. While any account may be selected under “Report Accounts” only importable accounts will report.
Imported as categorised
Shows the non-bank side of the imported transaction. To be reported the transaction must be named AND categorised.
Imported as allocated
Shows the non-bank side of the imported transaction. This includes the fully named and categorised transactions as well as the unnamed & un-categorised.
Imported as a journal
Shows all parts of each imported transaction - whether categorised or not. Results are further sorted to keep transaction components together. When using this form of report it is suggested you include export field “TransactionID”.
With any JobCode, With selected JobCodes
With any BizCode, With selected BizCodes
Fully named and categorised transactions with a job code OR biz code assigned that corresponds to the criteria selected…
Grouped export
For each group in the report list, the program selects transactions with business codes listed in the group. Report Groups include Code Types as well as custom defined Groupings. The sign of the transaction may also be considered. Records are reported / exported in blocks for each group with a summary of group totals at the end.
Grouped totals
Runs the same analysis as Grouped Export however does not export the report to a file. The group totals are simply reported in a separate window.
Grouped exception report
Reports all non-import side fully named and categorised transactions that do not have a business code allocated against them. The principal aim is to identify any categorisations that have not been correctly entered. To ensure the maximum benefit from this report you should use separate accounts for business and personal use + ensure that “Report Accounts” only includes these business accounts.
Search parameters
Reports and exports are limited by combination of all of the following:
- Date range: Note that either the From date or To date can be left unspecified. To consider all dates - leave both fields empty.
- Optional parameters determined by Report type. Simply check the options required from the drop-down menu.
Output formatting
All reports (with the exception of Grouped Totals) are exported to a file for subsequent printing or import into spreadsheets or other programs. Within each output group the order of records is fully sortable by the major record parameters. (E.g. date or category etc)
The following major formats are provided:
Comma separated, Tab separated (.CSV)
Basic format for import to other programs and spreadsheets. Column headers may be optionally added as required.
Text report, Text report + lines
Fixed width report with additional spaces added to keep all results within vertically lined columns.
Note that a non-proportional font should be used when viewing and printing these reports. Wide columns can be limited to a maximum width for limited width reports - otherwise the column widths shown in the Include Fields selection window will apply.
Include Fields
Includes Fields lets you specify the fields you want included in your report. It allows you to order these fields in the order that you would like them to appear, using the “Fields Included for Export” list.
Use the arrows to order the items up or down. The left arrow will remove the item from your list of selected fields.
