We've now released this update as the Cash Book System v3.1 - as cover in our Development Desk ticket here.
This is personally branded and available for business members and purchasers of the system and is available from the downloads area.
A trial version is now also available on the Cash Book System details page.
Enhancements
Cash and Accrual Based VAT reporting
VAT can be dealt with on a cash or accrual basis, chosen from a new drop-down option on the Lead sheet.
Accrual based VAT requires no changes, with VAT entered for Invoices or Credit Notes. Cash based VAT also needs a VAT component to be included for receipts and opening balances (for error checking).
Trial Balance
A clear and easy to use Trial Balance report has been added to the template. This provides a list of all accounts and their debit and credit balances, as well as a single column total. This report includes movement for all accounts in the current month, as well as YTD balances.
Improved Error Handling
Error handling has been added for credit notes and receipts. If a figure is not entered as a negative, the cell will be highlighted in yellow.
Error checking has also been added for the new cash based VAT. The VAT input cell will turn blue if the receipted VAT exceeds the VAT total outstanding for the customer/supplier at that same date.
Overall we have been pleased to be able to provide these additional features to this Excel Cash Book Template, and hope you find them useful.
Please do provide any feedback you like as it helps us build better templates for you!
[Read More...]