does numbers have a check register

Here's a working document based on an old template, modernized for recent versions of Numbers.

Checking Register.numbers (click link to download from Dropbox).

It looks like this:

In the version on one sheet (shown here) debits and credits are together. In the version on the second sheet debits and credits are shown in separate columns.

You can choose the sheet you like and File > Save as Template...

SG

When you create a new Numbers document using the Numbers menu item "File > New…", you get a dialog that lets you choose a starting template. I suggest trying the "Personal Savings" template:

The last version of Numbers to contain a cheque register template was

Here's a screenshot of the two tables and the Expenditure by Category included in the single sheet template.

The Transaction table contains one formula, entered as displayed at the top of the list below in cell F3, then filled down to the last cell in that column.

All cells containing money amounts have their Data type set to Currency Currency. All except F1 also have the "Accounting Style" box checked and the negative number style set to 'enclose in parentheses.'

Type lists the payment method for each amount, using cheque numbers to mark a payment by cheque, Debit Card for a purchase done with a debit card and DEP for any payment into the account.

Credit Card is not included as a payment method as it does not directly cause a withdrawal of money from the balk account.

Treating "Credit Card" as a spending category does mess up the categories chart though—lumping 37% of what was spent in the time shown into the second largest 'category' in the "Expenditure by Category chart shown.

Formulas used in the Account Categories table:

Two formulas are used here.

The first, which sums a single category, is entred as shown in Account Categories::B2 and filled down to row 6.

The second, entered in B7, requires row 7 to be defined as a Footer Row.

With rows 1 and 2 defined as Header rows, and row seven defined as a Footer row, SUM(B) will sum all values in column B except those in the Heade r and Footer rows. This avoids the self reference error that would occur if the formula included its own cell (B7) in the calculation.

Shoould be a relatively easy construction task.

Regards,

Barry