✅ 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. | 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* | 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 – full month during beta. | Straight line | = Straight line |
🟨 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). | 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 |
| Ensure the Source Account matches the GL name in QBO exactly and is actively being tracked by Keeper as an accrual task. |
| Use MM-DD-YYYY format |
| Enter duration in months (e.g., |
| 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 support@keeper.app.