How to do Bookkeeping on Excel using Asap Books

  • Step 1: Open Your File

    - If you are using Google Sheets, a link is provided within the file.

    -To begin, go to File → Make a Copy and save your own version.

    Screenshot of a Google Sheets document with a cell containing a link to a Google Sheets document and a note advising not to edit the total tab links.

  • Step 2: Choose the Month

    - Navigate to the tab for the month of financial activity you want to record.

    A screenshot of a spreadsheet showing a financial ledger with columns for transaction, type, date, and description, layered with a navigation bar at the bottom for dashboard, financials, and months from January to April.

  • Step 3: Select Payment Type

    In Column B, choose the type of payment:

    - Cash In or Cash Out

    - Check, Wire, ACH, Debit Card, or Credit Card (for recording expenses paid through credit card).

    - For accrual basis accounting, options for Invoice and Bills are available.

    Excel spreadsheet showing a general ledger with columns for transaction, type, and date; a row for cash with a check under type.

  • Step 4: Enter Transaction Details

    In Columns C–F, enter the following:

    - Column C: Date of the transaction

    - Column D: Description (e.g., vendor, customer, or purpose)

    - Column E: Amount

    - Enter as a negative number for expenses (money leaving)

    - Enter as a positive number for income (money coming in)

    - Column F: Select the account from the list (Income or Expense)

    Excel spreadsheet showing a transaction from January 18, 2025, with a description for Bob Smith's landscaping income, a gross sales account, and an amount of $500.
Buy Now

Example Template Below