Cash book templates

Purpose

  • Build a spreadsheet template that creates one or many cash-book payments or receipts in one generate. Use it for repeating bank lines, such as a rent split or standing receipts, when you do not want to key each voucher by hand.
  • This is not Create Recurring on a saved payment or receipt. Recurring can run on a calendar. A cash-book template waits until you click Generate Cash Book Document.
  • Screen: Bank → Cash Book Template. The list icon opens Cash Book Template Listing.

Assistant

  • No live cash-book-template wizard. Ask “how to create a cash book template” or “how to generate cash book document”.
  • For one payment or receipt in chat, use Record an expense or Money received. See Cash book payment and receipt.

Before you start

  • Bank and general ledger accounts you will use already exist on the chart of accounts.
  • You know whether this template is Payment or Receipt.
  • Description is how you find the template later. Keep it unique.

Create a template

  • Bank → Cash Book Template.
  • Click New Template.
  • Select Template Type: Payment or Receipt.
  • Enter a unique Description.
  • Enter rows in the spreadsheet. Rules are below.
  • Click Save (Template).

Generate documents from a template

  • Select Template (type to search).
  • You may change description, dates, cheque no., line description, amount, or tax.
  • Click Generate Cash Book Document (cog).
  • After create, docno fills on the rows. Click a number to open that voucher.
  • Print or edit from Cash Book Listing.

Edit, save as new, and delete

  • Edit: select the template, edit rows or the header, then Save (Template).
  • Save as new: select a template, enter a different Description, edit if needed, then Save As New (Template).
  • Delete Template on the toolbar removes the selected template. It does not delete documents already generated.

Spreadsheet rules

  • Every line needs G/L Account, Amount, and tax if you use tax.
  • Several lines on one document: leave Docno blank. KinraSoft assigns it at generate.
  • First line of the document: Date and Bank Account. Optional: Cheque No, Pay To.
  • Second line and below: no Bank Account, Cheque No, or Pay To.
  • Do not put a blank row between lines of the same document.
  • Several documents in one template: separate documents with one blank row. Each document gets its own voucher number at generate.
  • KinraSoft ignores anything after two adjacent blank rows.

Template, recurring, and a single voucher

  • Cash Book Template (this page). A spreadsheet you generate when you are ready. One or many vouchers.
  • Create Recurring on Payment or Receipt. A scheduled or named template from a saved voucher.
  • Payment / Receipt form. One voucher with the full form.
  • Assistant Record an expense or Money received. One voucher in chat.

If something goes wrong

  • Generate did nothing useful. Remove extra blank rows. The first line of each document needs Date and Bank Account.
  • The second line created a second voucher. You put Bank Account, Pay To, or Cheque No on a continuation line. Clear those cells.
  • Cannot find the template. Search by the Description you saved.
  • You want it every month automatically. Use Create Recurring on a saved cash-book document, not only this template.
  • Account missing on a line. Every amount row needs G/L Account.