✅ 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)
Column Name | Description | Example |
Source Account* | The source account for the asset or prepaid item, exactly as it appears in 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. Must be a tracked Keeper account. | Software |
Schedule Takeover Date* | The date Keeper should start accruing the item (MM-DD-YYYY). | 01/01/2025 |
Book Balance as of Takeover Date* | The book value of the item on the takeover date. | 8000 |
Remaining Duration* | The number of months left to recognize the balance, starting from the takeover date. | 8 |
Method* | The amortization method. Currently fixed to Straight line – full month during beta. | Straight line |
🟨 Secondary (Optional Columns)
Column Name | Description | Example |
Class | Optional classification for department, service line, etc. | Sales |
Location | Optional location tag for location-based tracking. | New York Office |
Purchase Date | The date the transaction occurred (not the recognition start date). | 02/01/2025 |
⚠️ Including these optional fields ensures more accurate categorization, especially for clients using class/location-based reporting.
📤 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.