Step 1: Go to the Settings tab of the Period 01 (January) file and change the name (upper left) to something more meaningful to you.

Step 2: Decide on an expense category group for this account:  Business, NonProfit, Personal or Customized. Each Category Group allows for customization either on the Settings tab or in Period 01 (January) Deposits and Checks. Go to and click on Getting Started Guides to view more Expense Category Groups.

Step 3:  Enter your starting checkbook balance on the Checks row 2, column H.

Optional Set Up


Start tracking mileage at the beginning of the year with your Odometer reading on Cash&Charges row 3, column AL.

All Your Accounts

Highly recommended. Use the Account Balance Tracker to reconcile monthly activity on any accounts other than your checkbook. This will assist you in an easy review, by account, of how money is received, expensed, or owed. Open each month in sequence for balances to transfer automatically. Follow the Important Note on the ABT Show Help button to be able to print an accurate Balance Sheet


Budget Calculator:  go to the Settings tab and click on the Summary file found at the bottom of Step 2. Next click on the Budget Calculator tab and enter Period 1 (January) budget amounts in Column D. These budget amounts will show up on each month's Income&Expenses as well as the YTD Income Statement.

Repeating Transactions

Set up Repeating Transactions in this Period 01 (January). Do a little research to determine which transactions repeat each month (like bank debits) and set up the transaction description and amount in the Deposits, Checks, Cash&Charges and Account Balance Tracker worksheets. (If you do not plan to use this feature, you may easily hide these rows by placing your cursor on the line between Row 17 & 18; click , hold, and drag up to hide.)  Some common examples of repeating transactions include: rent or mortgage with due date, loan payments, and utility bills.

Cost Centers and 1099 info

Set up a Cost Center to track the Net-Balance of certain Subcategories in the following manner:  a.  Choose Subcategories that have both income and expenses. b.  Click on the Deposits and Checks tabs on this worksheet - Period 01 (January) and assign the Subcategory to the identical column number on each one.  (Examples include:   Rental Property A income paired with Rental Property A expenses; Sales of Product A paired with Cost of Goods Sold for Product A.) c. View the Cost Center balances in the Summary file on the Cost Center tab.      

Set Up