TRUMBLES T1 SMALL BUSINESS ACCOUNTING MODEL
TRUMBLES T1 OVERVIEW
T1
is a 5-year business accounting model suitable for small businesses
·
It is simple to
setup and use
·
Online Help is
available on: www.trumbles.com
·
Input cells are
coloured green, all other cells are locked and protected
·
Descriptions of
fields are provided inside heading fields
·
Unprotected spare
sheets are available for client’s own use
·
T1 requires
Microsoft Windows 10 or 11 and Microsoft Excel 2016+ or MS Office 365 (Desktop
versions only, T1 will NOT run on web versions of Excel)
·
T1 can hold over
6,000 business records, or up to 5 years (60 months) of accounting records,
whichever limit is reached first
·
T1 must be moved
into a trusted folder in order for all programs to work
Business
records (sales, expenses etc) are input via the Submit Records program which
performs the following actions:
·
Checks input fields
and reports errors
·
Generates business records in the
Submitted Records table and sorts the table in transaction date order by month
·
Generates payment
records in the Payments Records table and sorts the table in payment date
order. This table is used for maintaining payment records
·
Generates company
names and addresses in the Address Records table and sorts the table in name
order. This table enables Address Autofill when submitting records
·
Generates invoice
records and numbers in the Invoice Records table. This table is used for
tracking and progressing unpaid sales records
·
Assigns unique record numbers
·
Calculates a payment status for
every record
·
Creates a period code for every
record
·
Checks the validity of the model
and reports if there are issues
Reporting
T1
includes the following reports which are generated automatically:
·
Invoice Generator – Produces
client invoices in PDF format
·
Generate Reconciliation Table –
Produces a comparison table of submitted and payment records for reconciliation
purposes
· Generate
Accountants Workbook - Produces a macro-free, unlocked version of the workbook
suitable for accountants
· Generate
Return For MTD Filing - Produces output for use with existing third party MTD
Excel bridging software
·
Totals Report - Enables totals to
be filtered and viewed by accounting period. This report shows totals with and
without VAT and by individual or grouped transaction types (sales, expenses,
other money in and other money out)
· Change
Control - Automatically tracks and logs any changes made to previously
submitted records (deletions and amendments)
Other Features
·
T1 checks the
integrity of the model continuously. T1 Status is calculated at the top of the
Payment Records sheet. If the status equals OK, it means that totals add up
correctly and there are no invalid records. If the status equals Issues, you
will be guided on how to rectify the problem. Further details are provided in
Payment Records Help
·
Condensed and full
view toggle buttons can be used to switch between list only and wrap text views
·
The invoice
template incorporates indicative text to simplify setup
·
Invoice Alert,
Unpaid Days can be set. Invoice records will be highlighted red, amber or
yellow after the set number of Unpaid Days has been exceeded
·
A Currency Selector
enables you to switch the currency symbol between £, € and $
·
Lock Records can be
used to prevent amendments or deletions to filed records
·
The Bulk Uploads
template can be used to submit up to 500 records at a time
Familiarisation
· T1
contains example records to help you understand how it works, these records are
blanked out when you run the setup program.
· You'll be
able to add, amend or delete records and run the report generators
· If you
wish to proceed after you’ve reviewed the model, you can request and purchase
an activation key which will enable you to blank out the model and set it up
for your own business