TRUMBLES T1 SMALL BUSINESS ACCOUNTING MODEL

www.trumbles.com

TOTALS

The Totals sheet contains a highly versatile fully automated report enabling drill-down by period and by transaction type

In its normal unfiltered state, total amounts including VAT can be viewed by month against the following categories:

· Sales

· Expenses

· Other Money In

· Other Money Out

Totals are shown in row 9 and are calculated against filtered (visible cells) only

Grand Totals and the balance are calculated in columns J to L

You can filter and view totals by business period (month, quarter or financial year) using the filter down-arrow in cell B10 and by VAT quarter using the filter down-arrow in cell C10

Amounts can also be filtered by individual transaction type (i.e. X-Bank Charges) using the drop-down selectors in the green coloured cells in D8, F8, H8 and I8

You can switch off filters by clicking the Reset Filters button at any time

Examples of filters that can be applied are shown below:

Year 1 totals by month

1. Click on Reset Filters (switches off any previously set filters)

2. Click on the down-arrow in cell B10 and type YR1 in the search box

Year 2 Hardware & Software Purchases by month

1. Click on Reset Filters (switches off any previously set filters)

2. Click on the down-arrow in cell B10 and type YR2 in the search box

3. Click on the down-arrow in cell F8 and select X-HWare & Sware (Purchases, Non Capex) from the drop-down selection

Year 1 Qtr 4 Interest Received by month

1. Click on Reset Filters (switches off any previously set filters)

2. Click on the down-arrow in cell B10 and type YR1-Q4 in the search box

3. Click on the down-arrow in cell H8 and select I-Interest Received from the drop-down selection

Capital Expenditure by month, all years

1. Click on Reset Filters (switches off any previously set filters)

2. Click on the down-arrow in cell F8, ignore the drop-down selection and overtype the value in the cell with *CPX*