Cash Accounting Scheme
This article explains how to use the Cash Accounting Scheme rather than the Double Entry Scheme.
To use DIY Accounting package with a Cash Accounting scheme rather than the normal Double Entry scheme, only enter the values in Sales and Purchases when the transaction actually clears and use the cleared transaction date[1].
For a Cash Accounting scheme the information in Sales and Purchase would match the transactions in Cash...xls and Bank...xsl. (The easiest way I find to do this is to enter Sales and Purchases when reconciling against a monthly bank statement.)
Citations checked:
File with HMRC and Companies House
DIY Accounting Submit is HMRC recognised. It files VAT returns, and company accounts and confirmation statements to Companies House. £9.99 a year (£0.99 a month), with a free day pass to try it.