This sheet is used to enter all
of your business records:
·
You must enter all
records including all sales and expense transactions, bank charges, bank loans,
loan repayments, rebates, interest received, charges paid out etc. Every
financial transaction paid in or out of your business must be entered into this
sheet
·
Descriptions of
fields can be found by clicking inside input and heading cells
·
All cells are
locked and protected except for green coloured input cells
·
Individual records
are entered in green coloured input cells (row 7) and then submitted using the
Submit Records button
·
Total amounts are
calculated in columns AB – AE and can be sub-totalled by period in cell AA7
·
Records can be
filtered using the filters provided in row 8
·
Notes can be added
at any time in the Record Notes column (AF)
The blue buttons at the top of
this sheet can be used to perform the following actions:
·
T1ResetFilters
switches off any filters that may have been set in header row 8.
·
SwitchTo ListView/WrapView expands or collapses records
·
AmendRecord can be used to make changes. All
amendments are automatically logged and tracked in the Change Control sheet
(CC)
·
DeleteRecord can be
used to delete records. All deletions are automatically logged and tracked in
the Change Control sheet (CC)
·
T1LiveSave copies
your T1 business model into your chosen trusted T1 folder
·
T1BackupSave copies
your T1 business model into your chosen archive T1 folder
·
T1ResetViews resets
all views to normal. Click this button if you wish to restore to normal view
·
SubmitRecords is used to enter new records.
Records can be submitted individually by entering details in the green coloured
input cells (row 7). Records can also be uploaded in bulk using the Bulk
Uploads template
The Submit Record program carries
out the following processes:
·
Validates data and
prevents known errors and omissions
·
Auto-sorts records
into transaction date order
·
Generates record
numbers
·
Generates invoice
numbers for new sales invoice records
·
Creates invoice,
address and payment records
·
Reinstates the
formats of all input fields
If the field description box gets
in the way when submitting a record, simply click inside it and drag it to a
new position
New company names and address
records can be entered individually as you submit records
After a record has been
submitted, the new company name will become available to select in the future.
When you select a previously submitted company name from the drop-down
selector, address fields will auto-populate
Company names and addresses will
appear on Sales Invoices
Address records can also be added
or amended directly in the Address Records table
When
you submit a record, you will be required to assign an appropriate transaction
type from the drop-down selector provided
There are three built-in sales
transaction types which are listed below:
·
S-Non-EU Sales –
All UK sales and for sales into non-EU countries
·
S-EU Sales - All EU
sales records
·
S-Credit Note –
Return of funds
There
are also 28 built-in expense transaction types plus five other transaction
types (i.e. bank monies in and out)
All
sales transaction types are prefixed with S-, Expense transactions are prefixed
X-, Other-Money-In is prefixed with I- and Other-Money-Out is prefixed with O-,
Capital Expenditure is prefixed with X-CPX
The complete list
of available transaction types can be found in column C in the Setup sheet
Spare transaction
types are available in the Setup sheet if required. If you overtype a spare
transaction type name, it will immediately become available for you to select
and will appear in all reports automatically
Transaction
dates are translated into period codes which can be filtered in column E (cell
E8). Examples of period lookup codes are:
·
YR1-Q1-M01* (year
1, quarter 1, month 1)
·
YR2-Q3* (year 2,
quarter 3)
·
*Q3* (quarter 3,
all years)
·
YR2* (year 2)
To
ensure that VAT is recorded and reported correctly, you must apply the correct
VAT percentage rate and assign the appropriate transaction type
The HMRC website
section: How
to fill in and submit your VAT Return (VAT Notice 700/12) - GOV.UK (www.gov.uk)
provides details
As
records are paid, you’ll need to update the payment dates and amounts in the
Payments Records table. Further details can be found in the PayRecs sheet Help
The
updated payment status will then appear in your Submitted Records sheet (column
Z)
Bulk
Uploads is used for submitting multiple records i.e. uploading records from
bank statements by:
1.
Downloading the
Bulk Uploads template from: www.trumbles.com and saving it into a folder of
your choice
2.
Open the template
and follow the instructions for filling it in and validating the information
3.
Then close and save
the template
4.
Open your T1 model
5.
Change the Bulk
Uploads drop-down selector to ‘Y’ (cell R6)
6.
Click the Submit
Records button and follow the instructions
The Bulk Uploads
template is restricted to 500 records
The T1 model is
restricted to 6,000 records
If you are
uploading a high volume of records using multiple templates, save and close
your T1 model after each upload, then re-open it and upload the next 500
records