Financial Reports
The ValBiz System provides a number of standard reports. Each report details valuable management information from the system.
Select a link below to view samples of each report available.
Debtor Reports
Creditor Reports
Cashbook Reports
Ledger Reports
Analysis Reports
Work Reports
Commission Report
ValBiz Version 6 - Default Chart of Accounts
Generating a Report
The process to produce any of the reports is very similar. Here's an example for producing statements.
Note that the Export box can be ticked to send a formatted copy of this report straight into Excel, (for e-mailing or to further analyse the figures).
 Pressing the Debtors/Statements button gives you a standard report criteria screen.
Decide how you want the reports output to be ordered, change the range of clients you are running the report for if you wish, note the 'Options' text and any hints provided, then press Print to produce the report. Tick preview if you want to view it on the screen first. A Filter button is provided for specifying other more advanced criteria; this works in the same way as the ValBiz Generic Search tool. See the ValBiz Professional training manual for more information. |
Access the Debtor Reports options from the Toolbar Financial / Debtors
This statements menu item enables you to produce a 'statements of accounts' for all or selected Debtors.
Aged Debtor List by Staff For each selected Debtor it displays their current balance followed by a listing of each invoice outstanding, the monetary amount is listed in the appropriate ageing column. This listing is sorted and totalled by the staff member who was assigned the matter that the individual Debtor invoices relates to.
Aged Debtor List by Firm For each selected Debtor it displays their current balance followed by the monetary amount that is listed in the appropriate ageing column.
(Debtor) Transaction Report Lists individually, all invoices and credit notes, receipts and debtor journals raised over a selected time period. This report has options to filter by Invoice/Credits, Journal, Receipts, or exclude fully allocated invoices. The report displays a column for the gross amount of the invoice and another column displaying the GST element of the invoice.
Debtor Ledger Report Gives a complete listing of all transactions for a selected Debtor for a selected time period. Together with an opening and closing balance. You also have the option to show all allocations and transactions, or just a summary.
Access the Creditors Reports options from the Toolbar Financial / Creditors.
Payments Due Report Lists the total amount due for payment; sorted by Creditor account code, account name, payment method and amount due. The option to include each transaction is optional, at the report generation time.
(Creditors) Aged Trial Balance For each selected Creditor it displays their current balance, followed by a listing of each invoice outstanding. The monetary amount is listed in the appropriate ageing column. The option to include each transaction is available at the report generation time.
(Creditors) Transaction Report Lists individually all invoices and credit notes, payment and creditor journals raised over a selected time period. This report has an option to filter by Invoice/Credits, Journal, Receipts, or exclude fully allocated invoices when you are generating the report. The report displays a column for the gross amount of the invoice and another column displaying the GST element to the invoice.
(Creditors) Outstanding by Code Lists all Creditors invoices overdue ordered by General Ledger code.
Access the Cashbook Reports options from the Toolbar Financial / Cashbook.
Cashbook Other Report Lists the posted standing payments and receipts for a selected time period. The Net, GST and Gross amount is shown on the appropriate column. There is also an option to filter by receipts, payments or to include details at the report generation time.
Note: Only transactions that have been recorded via 'cashbook other' functionality are shown in this report.
Cash Movement Report Lists all deposits and withdrawals recorded on the system.
Banking Report Provides a list of all deposits over a selected time period, including a drawer name, bank, branch and amount banked.
Note:
Other banking reports are available from the 'Cashbook Debtors: Enquire Change Screen'
Bank Reconciliation reports are available from the 'Bank Statements Screen'
Cash Analysis Report This report will list for all of the selected time period with the cashflow broken down by the ledger groups of Debtor, Creditor, Payroll & GST. You have a tick box option to list transactions if required.
Cash Forecast Report Based on information entered in ValBiz. Output can show the cash position in either daily, weekly or monthly intervals of expected cash inwards and outwards. Output is either by Excel or Graph.
Access the Ledger Reports options from the Toolbar Financial / Ledger.
G/L Analysis Report Lists the posted transactions for each analysis code for a given period.
G/L Ledger Reports Produces the Financial Statements
These include:
The Profit and Loss (Simple)
The Profit & Loss (Extended)
Balance Sheet
Trial Balance
Budget: Valbiz has the ability to include budgets. This is in the same format as your Profit and Loss and can be printed individually or as an extra column on your Profit and Loss Statement. The example shows the Actual for August with an extra column showing the monthly Budget.
Note: Two examples are shown for the Profit and Loss Statement; one very simple and the other extended, to show more accounts. These reports can be expanded and configured to your company's requirements.
G/L Journal Report Lists all journal entries over a selected time period.
Access the Analysis Reports options from the Toolbar Financial / Analysis Reports.
All amounts are exclusive of GST in the following reports.
The Profit is calculated by the Fees plus Mileage plus Disbursements less any time/costs writing to the matter. (exclusive of GST)
The Margin is the Profit divided by the Time Cost
Staff Detail Analysis A summary of fees, mileage OR disbursements earned within a selected date period for selected Staff Members. There is an option to group by Worktype. Each matter is listed along with the date and address.
Disbursement Detail Analysis A listing of disbursements by type and amount.
Receipt Fee Detail Analysis Lists the amounts paid (exclusive of GST) by Debtors for selected staff members for a selected date range.
Staff Monthly Analysis For a selected staff member, lists the total of the current period fee earned, the receipts for the current period, the Year to Date (YTD) fees earned and Year to Date (YTD) fee receipted.
Note: you can run this report for fees or mileage.
Disbursement Monthly Analysis Gives a total of disbursements raised by type for the period. There are two columns for the current period showing invoiced and receipted, and another two columns for the Year date figures.
Work Type Monthly Analysis A summary of income earned by period (and YTD) for selected offices.
Office Monthly Analysis A summary of income earned by period (and YTD) for a selected office.
Access the Work Reports options from the Toolbar Financial / Work Reports.
All amounts are exclusive of GST in the following reports.
The Profit is calculated by the Fees plus Mileage plus Disbursements less any time/costs writing to the matter.
The Margin is the Profit divided by the Time Cost
Unfinalised Invoices by Staff Lists the invoices not set as final by the Staff Member responsible, along with the matter number.
Invoices Raised by Staff Lists the Matter Number, Debtor, Fees earned, Disbursements, Mileage, Time Cost, Profit and Percentage Margin for a selected staff member. The Profit is calculated by the Fees plus Mileage plus Disbursements less any time/costs writing to the matter. (exclusive of GST)
Uninvoiced Matters by Staff Lists matters by staff member and job number that have not yet been invoiced. Also lists the instruction date, debtor name, firm, matter status flag and addresses. Option to exclude completed matters, time and KMs/disbursement
Uninvoiced Time/KmDisb lines by Staff Lists all matterswith time written but no invoice created. Lists job number, debtor name, date, staff hours/kms or disb and totals columns.
Work Type Totals lists the total number of Matters (quantity) the Time Cost, Profit and % margin for each selected work type in the selected time period.
Staff Work Report lists the Worktype, Invoice Quantity, Fee, Mileage, Disbursements, Time Cost, Profit and Margin for a selected staff member. There is an option to list all matters separately or to total by Worktype.
Staff Receipt Report Lists the receipt date, reference, Debtor, Receipt Net, Invoice No, Invoice Net, % percentage allocated and allocated to staff.
Access the Commission Report options from the Toolbar Financial / Commission Report.
Many ValBiz Clients employ staff that are paid on a commission basis. The Commission Report lists individual invoices and credit note fee lines for a selected staff member. Extra columns for the percentage commission due are presented.
This report has an option to filter by invoice or receipt basis over a selected period of time. A summary of the total commission due for the period selected is calculated and presented at the bottom of the report.
