Skip to main content

📥 How to Import an Accrual Schedule via CSV

If you're moving from spreadsheets to Keeper Accruals, importing your existing schedules via CSV is the fastest way to get started.

Updated over a week ago

✅ 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 – full month during beta.

Do not change

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).

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

  1. Go to the Accruals tab for a client.

  2. Click “Batch import” in the upper-right corner.

  3. Select and upload your file.

  4. Keeper will validate your data in real time.

  5. Review flagged rows (if any) and correct errors before submitting.

  6. 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.

Invalid date

Use MM-DD-YYYY format

Duration is blank or non-numeric

Enter duration in months (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 support@keeper.app.

Did this answer your question?