After an email request from a new member, we've update the Cash Book System to version 2.2.

The request we received was to include an analysis function and unlock the unused space in the Excel template for workings. We've added a few other improvements also for your benefit.

It is now available for download in the Tools & Templates Download section.

Enhancements

Analysis Function
An optional analysis of up to 10 additional categories can be done on each transaction.

This could be used for:
 • Departments/Cost-Centres
 • Project Costing
 • Sales Performance
 • Individual/Personal expenditure

Analysis Summary
A summary page is provided showing total of every receipt and payment account by analysis.
Included is the total receipts and payments along with the variances that have not been allocated for analysis.

Macros Disable Notification
If macros have not been enabled, a notice is provided indication this and that the Cash Book System will not operate correctly.

Bank Methods and Account Selection Highlighting
When an entry has been made and not yet allocated to a receipt/payment method or an account, these cells are highlighted to indicate this.

Unlimited Transactions
Additional rows for Receipts and Payments can be added when needed up to Excel's own limit (previously the system allowed for 2000 of each payments and receipts).
More efficient file size as only a minimum number of spare transaction rows need to be stored.

Unlocked Workspace
Workspace at the sides, and below with the reporting sheets, has been unlocked to enable you to easily do your own calculations or show workings

Analysis Function

We will be looking at simplifying the system an analysis form for allocating to your analysis categories. At the moment it uses a flexible analysis split coding system, which works as follows:
 • Up to 10 categories you would like to use are entered on the Lead sheet.
 • To the right of transactions appears a Analysis Code Entry Box, followed by the split across each category.
 • Above each category appears the analysis code to use in the Analysis Code Entry Box. eg. The first category will use the code 'A', the second will use code 'B' and so on.
 • The code is entered as a single entry for an entire split, in the form of the Category Analysis Code followed by a numerical split.
 • The numerical split is proportional but is always 100% of the transaction once analysed. Therefore it can be as a percentage, an amount or a straight proportion.

Examples

1. To split across the first and second categories as 20% and 80% respectively, the code would be 'A20B80'.
2. To split a £100 transaction across the first and third categories as £67.50 and £32.50 respectively, the code would be 'A6750C3250'
3. To split across the second and third categories as one-third and two-thirds respectively , the code would be 'B1C2'

Notes
Example 1. This split would also work with the codes 'A2B8' or 'A1B4' as the proportions are the same as 20/80.
Example 2. Decimal points must be removed from the coding, but ending zeros can be dropped if preferred (such as using whole dollar amounts only).
Other - If you do not wish for 100% of a transaction to be entered, you could either create an 'unallocated' analysis category or split it into 2 transactions for the amount to be analysed, and the amount to be unallocated.

Please provide any feedback you may have in the Tools & Resources Feedback forum. Further requests for features can be made at our Development Desk.

Kind regards