Skip to main content

QBDT: Create & Export Balance Sheet (By Month)

Goal​

Export a Balance Sheet by Month in Accrual basis for a date range you want BizVisualizer to analyze.

Step 1: Open the report​

  1. In QuickBooks Desktop, go to Reports menu
  2. Select Company & Financial
  3. Choose Balance Sheet Standard

Step 2: Customize the report​

Click Customize Report and set:

  • From Date: as far back as you want to analyze
    • We recommend at least 16 months (or more if you have it)
  • To Date: the last month where transactions are entered and reconciled
  • Report Basis: Accrual
  • Display columns by: Month (across the top)
warning

Do not use Cash Basis. BizVisualizer expects Accrual reports.

Click OK.

Step 3: Export to Excel (or CSV)​

  1. Click Excel
  2. Choose Create New Worksheet
  3. In the dialog box that comes up, choose in new workbook under Create new worksheet
info

If Excel isn’t installed on the computer running QuickBooks Desktop, QuickBooks may only offer a Create a comma separated values (.csv) file export option. That’s OK. The BizVisualizer can read CSV files too.

  1. Click Advanced and confirm:
    • Space between columns unchecked
    • Auto Outline unchecked
    • Auto Filtering unchecked
    • Include QuickBooks Export Guide unchecked
    • Click OK

Click Export.

In Excel, save the file with a name and location you can easily find later. For example:

BS 2023-01 to 2026-01.xlsx

Step 4: Memorize the report (one-time setup)​

Memorizing makes monthly updates much faster.

  1. Click Memorize
  2. Name it something you’ll recognize, such as:

BV Balance Sheet by Month from 2023-01