📥 How to Import an Accrual Schedule via CSV

✅ When to Use This

You want to migrate historical schedules.
- You'll probably want to do this the first time you use Keeper Accruals.
You manage schedules outside of Keeper (e.g., in Excel) and want to bring them into one centralized area.
You’re creating multiple accruals at once and want to do it in bulk.

🧾 CSV Format Requirements

Your file must follow the required column headers exactly for a successful import.

🟩 Primary (Required Columns)

*indicates a required field for a successful upload

Column Name	Description	Example	Suggested Formula for CSV
Source Account*	The source account for the asset or prepaid item as per your chart of accounts.	Prepaid Expenses	= Source account column
Vendor/Payee*	The vendor or payee for this item. Must match the name in QuickBooks Online.	Salesforce	= Vendor column
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. Please include the account number and special characters, if applicable.	Software	= Expense account column
Date posting starts*	The date that Keeper should start posting accrual journal entries from (MM/DD/YYYY). e.g., If you already have journal entries up until July 31st, then this date should be August 31st. This means Keeper will start posting the remaining JEs automatically from August onwards. If this is a one-time recognition, then the date should be the month you wish the one-time JE to be posted in.	08/31/2025	= Ending day of the month you wish the next JE to be posted in
Original Cost* (Only applicable to fixed assets)	The purchase price of the fixed asset at acquisition (excluding accumulated depreciation).	12000	= Purchase price
Book Balance as of Takeover Date*	The book value of the item on the date the posting starts. e.g., If the beginning balance was $12,000, but 6 out of 12 months have been accrued, then this value would be $6,000	6000	= Purchase price - Total recognized to this point
Accumulated Depreciation as of Takeover Date* (Only applicable to fixed assets)	The total depreciation expense recognized to the takeover date for the asset.	6000	= Purchase price - Book Balance as of takeover date
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	= ROUND( Total remaining balance / Amortization amount , 0)
Method*	The amortization method. Currently fixed to Straight line during beta. Do not change	Straight line	= Straight line
Convention*	The amortization convention. During the beta you can choose between Full month or Mid month convention.	Full month	= Full month

🟨 Secondary (Optional Columns)

Column Name	Description	Example	Suggested Formula for CSV
Class	Optional classification for department, service line, etc. (must match QBO)	Sales	= Class column
Location	Optional location tag for location-based tracking.	New York Office	= Location column
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	= Date billed column

⚠️ Including these optional fields ensures more accurate categorization, especially for clients using class/location-based reporting.

Important notes:

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

📤 How to Upload Your CSV

Go to the Accruals tab for a client.
Click “Batch import” in the upper-right corner.
Select and upload your file.
Keeper will validate your data in real time.
Review flagged rows (if any) and correct errors before submitting.
Click “Import” to import your schedule and begin posting JEs.

🧠 What Happens After Upload

Keeper creates accrual schedules for each line item.
Journal entries are automatically posted based on your recognition logic.
Each schedule will show:
- Monthly amortization entries
- Source account
- Posting account
- Remaining balance
- Linked documentation

🔁 Imported accruals will begin posting immediately.

❌ Common Upload Issues

Issue	Solution
`Account not found`	Ensure the Source Account matches the GL name in QBO exactly and is actively being tracked by Keeper as an accrual task. Note: You may have the Account Number enabled and you're forgetting to include it!
`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 positive number to create an accrual

💬 Still Need Help?

If you're unsure about how to format your file, reach out to us at help@keeper.app.

Catch up with Keeper Webinars

📘 Keeper Accruals Overview

🥇Setting Up Keeper Accruals for the First Time