Cashbook template: reconcile cash and hand over a completed business day

A business searching for a cashbook template often wants to organize receipts and physical cash first. A simple worksheet can help by making balance movements and missing evidence visible. Before using it, establish whether you need a reconciliation aid, the actual statutory cash records, or a handover of a day already closed elsewhere.

This template supports reconciliation and handover. Recording duties depend on the business and its process. In Germany, section 146 of the Fiscal Code includes daily cash recording and traceable changes among its requirements. A spreadsheet title or a saved PDF does not by itself demonstrate that those requirements have been met.

Create a separate reconciliation for each source of physical cash. Record the date, cash source, responsible person and original evidence reference at the top. Copy the fields below into your worksheet. List movements individually or with an unambiguous reference to the underlying compliant records. The worksheet must not replace the detailed information those records need to preserve.

Record each movement once. Use separate receipt and payment columns and keep references that let another person find the evidence. Card receipts do not belong in cash receipts. Moving money between the bank and a cash box changes both balances, but the transfer itself is not revenue or an expense.

This simplified example illustrates physical cash reconciliation, not a complete tax posting instruction. The day starts with EUR 200 in the cash box. Cash sales add EUR 350 and a documented contribution adds EUR 50. The business pays EUR 40 in cash and takes EUR 400 to the bank. The expected closing cash balance is EUR 160.

Recording the bank deposit again as a business expense confuses a transfer with an expense. A contribution is not automatically revenue either. Its legal and tax treatment depends on the actual transaction and, among other factors, the entity type. For the physical balance check, establish which cash actually entered or left the cash box.

The example leaves a five-euro shortage against the expected balance. Count again, then review the movements. Was a receipt included twice? Is a cash payment missing? Was a card payment classified as cash? Was a contribution or withdrawal assigned to another day? Compare the worksheet with the actual original evidence.

When you identify an error, document its cause, the responsible person and the traceable correction. If the difference remains unexplained, record that fact and agree its treatment with the person responsible for accounting. Do not invent a sale or document to force the balance to match. A negative calculated cash balance also requires investigation because a physical cash box cannot contain less than zero.

A freely editable file can make later changes hard to reconstruct. If spreadsheets form part of your procedure, organize responsibilities, evidence of changes, original documents and retention as well. Exporting a PDF later does not automatically establish how the figures arose or whether earlier versions were changed.

A template cannot settle the question of a technical security device either. Electronic recording systems within the scope of section 146a of the German Fiscal Code are subject to their own requirements. Determine the applicable duties from the actual system and process. Transferring totals to accounting software afterwards does not replace that assessment.

A useful handover contains more than a total. Accounting needs to identify the cash source and business day, trace the figures to their evidence and understand whether differences have been resolved. Consistent identifiers are especially useful across several locations. They also help prevent importing the same completed day twice.

Retain documents according to their type and the applicable requirements. A posting document, cashbook and supporting procedure documentation can fall under different retention rules. Avoid applying one blanket period to every file. Regularly test that the original evidence remains readable and connected to the right daily close.

accuno backoffice cash starts with a business day already closed outside accuno. Assign the cash source to an accounting cash account, transfer the daily totals and attach original evidence. Review the expected balance, counted cash, difference and posting preview together before final posting. Necessary corrections to posted days use traceable reversal and a new revision.

Individual sales, payments, receipts and technical security device control remain outside accuno. The product does not replace a point-of-sale register or responsibility for recording transactions on site. It supports subsequent reconciliation and controlled transfer to financial accounting. Use the worked example as an initial test, then follow a real day already closed in your existing process with its original evidence.