How to import an accrual schedule

When you start using Accruals, you'll likely need to import your old accruals schedule to our platform in order to start managing your schedules here.

Accruals is only available to clients on the Scale subscription. Admins are able to upgrade clients to Scale in their Practice Settings.

Importing via Ask Double

You can import certain accrual schedules directly through Ask Double instead of preparing a CSV template first.

Ask Double can help you import:

Prepaid expenses
Fixed assets
Deferred revenue

To import with Ask Double:

Open Ask Double for the client.
Upload your accrual file in the chat.
Tell Ask Double you want to import the accrual schedule.
Answer any follow-up questions Ask Double asks about the file or the schedule details.
Review any suggested account, vendor, or value matches.
Review the Import review modal before proceeding.

Good to know

Ask Double will review the import before posting anything.
If Double finds missing or ambiguous information, Ask Double will ask follow-up questions before continuing.
If the posting period is locked, the import may be blocked until the period is unlocked or the schedule details are adjusted.
After the import starts, Double will provide a link to the relevant Accruals page.

Video overview

Importing via CSV

If you already have your accrual data in Double’s import template format, batch import is the fastest manual option.

Go to the Accruals page in a client and click the Batch import button on the top right.

Import templates are available by clicking "Batch import" in the Double platform. They are also available for download at the bottom of this page.

Fill these templates with any accruals you'd like to add to Double, and then upload the file.

After you upload the file, Double will validate your data so you can review your data before importing.

Once you have reviewed the data, Double will create new accruals schedules for each line and post all future Journal Entries associated with those schedules.

See below for an overview of how each column of the import file should be mapped.

Video overview

When to use Ask Double vs CSV import

Use Ask Double when:

your source file is not already in the template format
you want help interpreting or mapping the schedule
you want a guided import flow

Use CSV import when:

your schedule is already in Double’s template format
you want to bulk upload directly
you prefer a spreadsheet-first workflow

Prepaid expenses columns

*indicates a required field

Column Name	Description	Example
Source Account*	The source account for the asset or prepaid item as per your chart of accounts.	Prepaid Expenses
Vendor/Payee*	The vendor or payee for this item. Must match the name in QuickBooks Online.	Salesforce
Expense Account*	The account that will be debited as the expense is recognized. This must be the exact name of the account, as shown in the chart of accounts.	Software
Date posting starts*	The date that Double should start posting accrual journal entries (MM/DD/YYYY). e.g., If you have posted journal entries through July 31st, then this date should be August 31st. This means Double will start posting the remaining JEs automatically from August onwards. If this is a one-time recognition (like a conference), then the date should be the month you want the one-time JE to post.	08/31/2025
Net Book Value as of Takeover Date*	The book value of the item on the date the posting starts. The Takeover Date is the start of the close you are uploading the file into. For example, if you're uploading accruals in the August 2025 close, Aug 1, 2025 is the takeover date. e.g., If the beginning balance was $12,000, but 6 out of 12 months have been recognized, then this value would be $6,000.	6000
Remaining Duration*	The number of months left to recognize the balance, starting from the date the posting starts, as indicated in the column above.	6
Method*	The amortization method. Currently only supports Straight line - do not change.	Straight line
Class	The class that will be added to the amortization entry (must match QBO classes).	Sales
Location	The class that will be added to the amortization entry (must match QBO classes).	New York Office
Purchase Date	The date the transaction occurred (not the recognition start date). e.g., A purchase was made in February, but it will start being accrued as of April; this date should be in February.	02/01/2025
Description	A description of this prepaid expense.	Annual CRM license

Fixed assets columns

*indicates a required field

Column Name	Description	Example
Source Account*	The source account for the asset or prepaid item as per your chart of accounts.	Computers: Original Cost
Vendor/Payee*	The vendor or payee for this item. Must match the name in QuickBooks Online.	Apple
Expense Account*	The account that will be debited as the expense is recognized. This must be the exact name of the account, as shown in the chart of accounts.	Depreciation
Date posting starts*	The date that Double should start posting accrual journal entries (MM/DD/YYYY). e.g., If you have posted journal entries through July 31st, then this date should be August 31st. This means Double will start posting the remaining JEs automatically from August onwards. If this is a one-time recognition (like a conference), then the date should be the month you want the one-time JE to post.	08/31/2025
Original Cost*	The purchase price of the fixed asset at acquisition (excluding accumulated depreciation).	3600
Net Book Value as of Takeover Date*	The book value of the item on the date the posting starts. The Takeover Date is the start of the close you are uploading the file into. For example, if you're uploading accruals in the August 2025 close, Aug 1, 2025 is the takeover date. e.g., If the beginning balance was $12,000, but 6 out of 12 months have been recognized, then this value would be $6,000.	3000
Accumulated Depreciation as of Takeover Date*	The total depreciation expense recognized to the takeover date for the asset.	600
Remaining Duration*	The number of months left to recognize the balance, starting from the date the posting starts, as indicated in the column above.	6
Method*	The amortization method. Currently only supports Straight line - do not change.	Straight line
Class	The class that will be added to the amortization entry (must match QBO classes).	Sales
Location	The class that will be added to the amortization entry (must match QBO classes).	New York Office
Purchase Date	The date the transaction occurred (not the recognition start date). e.g., A purchase was made in February, but it will start being accrued as of April; this date should be in February.	02/01/2025
Description	A description of this fixed asset.	Laptop

Deferred revenue columns

*indicates a required field

Column Name	Description	Example
Source Account*	The source account as per your chart of accounts.	Deferred revenue
Customer*	The customer for this revenue. Must match the name in QuickBooks Online.	Amy's Bird Sanctuary
Recognition Account*	The account that will be credited as the invoice is recognized. This must be the exact name of the account, as shown in the chart of accounts.	Subscription Sales
Date posting starts*	The date that Double should start posting accrual journal entries (MM/DD/YYYY). e.g., If you have posted journal entries through September 30th, then this date should be October 31st. This means Double will start posting the remaining JEs automatically from October onwards. If this is a one-time recognition (like a conference), then the date should be the month you want the one-time JE to post.	10/31/2025
Net Book Value as of Takeover Date*	The book value of the item on the date the posting starts. The Takeover Date is the start of the close you are uploading the file into. For example, if you're uploading accruals in the October 2025 close, Oct 1, 2025 is the takeover date. e.g., If the beginning balance was $12,000, but 6 out of 12 months have been recognized, then this value would be $6,000.	2000
Remaining Duration*	The number of months left to recognize the balance, starting from the date the posting starts, as indicated in the column above.	12
Method*	The amortization method. Currently only supports Straight line - do not change.	Straight line
Class	The class that will be added to the amortization entry (must match QBO classes).	Enterprise
Location	The class that will be added to the amortization entry (must match QBO classes).	San Francisco
Invoice Date	The date the transaction occurred (not the recognition start date). e.g., An invoice was sent in February, but it will start being recognized as of April; this date should be in February.	10/1/2025
Description	A description of this invoice.	Laptop

NOTE

If you leave one blank row in the CSV it will indicate the end of the data that you wish to import
Dollar amounts in the CSV should be in the US format only
- e.g. $1,254.03 or 1,254.03 or 1254.03 are acceptable formats

Troubleshooting upload issues

Issue	Solution
`Account not found`	Ensure the Source Account matches the GL name in QBO exactly and is actively being tracked by Double as an accrual task.
`Invalid date`	Use MM-DD-YYYY format
`Duration is blank or non-numeric`	Enter duration in months greater than 0 (e.g., `12`)
`Starting balance = 0`	Must be a non-zero number to create an accrual.

Import templates

double_accrual_template_prepaid.csv

double_accrual_template_deferred_revenue.csv

double_accrual_template_fixed.csv

Accruals Overview

Getting Started with Accruals

How to Dispose of or Impair a Fixed Asset

Sage Intacct: Prepaid expenses

Getting Started with Loan Amortization