Open your spreadsheet software on your computer. Click "New from template." A window will appear with common spreadsheet categories such as Budget and Invoice. Type "Account Register" or "Checkbook Register" into the search bar and click "OK." Select a template from the list of available templates. Although templates come standard in most spreadsheet software, the styles of each template will vary.
Select a register inclusive of the date, purchase description, and a credit and debit column. The register you choose should also have a column to indicate whether the purchase has posted to your account.
Use receipts from your debit card purchases to enter transactions into the register. If you are missing receipts, use your bank statement to complete the register. Your most recent transactions may have to be entered from memory if they are also not available on your statement.
Open your checkbook ledger to the first page of the booklet. Write the account number of the debit card you are tracking in the space provided. You can enter your name or the name of your bank next to "Name:"
Turn to the first page of the registry. This page has a series of rows and columns in white and gray.
Enter the date of your transaction, a description of the transaction and the amount one of the columns labeled "Deposit/Credit" or "Payment." Write the starting balance on the first line under "Balance." The first column of your ledger is dedicated to entering your check number or a bank transaction code. Transaction codes such as "AP" for automatic payment or "FT" for funds transfer are most relevant for tracking bank account activity, but can be used for some debit card transactions.