Browse
 
Tools
Rss Categories

How to Import Bookkeeping Ledger Entries from CSV or OFX

Overview

This tutorial explains how to import bookkeeping ledger entries into StudioCloud

How to Import Bookkeeping Ledger Entries from CSV or OFX

  1. Click on the Bookkeeping component
  2. Click on the Accounts tab
  3. Click the Accounts button
  4. Select the checkbox for the account you want to import the entries into
  5. Click the Import Options menu
  6. Select the Imported From File Into Selected Account menu item
  7. In the Import Bookkeeping window click the Import Options menu
  8. Select the Import from CSV (Comma Separated), Import from CSV (Tab Separated), or the Import from OFX File menu item
  9. Browse for and find the file you want to import and click the Open button
  10. Verify that the information looks correct.  If the information does not look correct then please make sure that the file you are importing matches the column order in the Import Bookkeeping window
  11. Click the Save button

Expected CSV (Comma Separated) Format

StudioCloud is expecting the csv file to have the following information in the csv file. The csv file might also contain additional information then what is listed below. In that situation you would want to set the additional column headers to blank.

  • Date format where the date is in one of the following formats
    • MM/DD/YYYY
    • DD/MM/YYYY
    • YYYY/MM/DD
    • DD-MMM-YY
    • MM/DD/YY
  • Check Number
  • Notes
  • Debit
    • This column might also be a Debit/Credit or a Credit/Debit column. 
  • Credit
    • This column might also be a Debit/Credit or a Credit/Debit column.
  • Payee

Debit/Credit vs Credit/Debit

The Debit/Credit and Credit/Debit fields are used when both positive and negative amounts are stored in the same column.

Debit/Credit - If the amount is less than 0 then this will be treated as an expense.  If the amount is more than 0 then this will be treated as an income.

Credit/Debit - If the amount is less than 0 then this will be treated as an income.  If the amount is more than 0 then this will be treated as an expense.