How do I manually import bank transactions?

How to Manually Import Bank Transactions

If you are having issues syncing your bank account or need to manually upload your transactions, follow these steps. 

Step 1: Create A Bank Account

To manually import a list of transactions from your bank, start by selecting Add new account in the Bank Account section. You will need to either link your bank account or manually upload bank transactions (if this is completed, skip to Step Two: Data Migration).
  1. On the left navigation menu, select Bank Accounts.
  2. In the top left corner, use the dropdown menu to Add a new account.

Enter the basic information for your new account, most importantly:
  1. Account name
  2. Description
  3. Account number: Your account number should be the last 4 of the bank or credit card you are adding
  4. Account type
    1. For Checking/savings accounts, select the account type: Bank and liquid assets
    2. For Credit cards, select the account type: Credit cards

Step 2: Data Migration

Now it's time to locate the data that you would like to migrate to Sunrise. 

Log into your bank/credit card account. You should be able to export the data from a specified time period. You will need to download it as a CSV file so it is easy to upload to Sunrise.
The CSV file should have at least these headings: 
  1. Date (use format MM/DD/YY)
  2. Description (remove single (') or double quotes ("))
  3. Amount 
    1. Use one column with a number and positive amounts
    2. Format as XXXX.XX and remove any symbols ($, €, etc.)

Step 3: Upload Statement

Now that you have an account created and a CSV prepared, you can upload the CSV to the bank account that you created in step 1.

In your Sunrise account go to:
  1. Bank Accounts in the left navigation menu. 
  2. Select the account from the dropdown that you would like to import the CSV to. 

Important Tip: Confirm the last 4 digits of the bank account in Sunrise matches the last 4 digits of the credit card or account statement.
  1. Click on Match transactions.
  2. Click on Upload statement.
  3. Click on Upload bank statement.
  4. Follow the prompts to upload the CSV file you prepared in Step 2.
  5. Identify each column and click Import now.

Error in uploading: Select the headings from the dropdowns to match the data in that column (Date, Amount, Description) OR confirm the numbers and dates are formatted properly in the CSV file as shown in Step 2.

Note: Test a few lines of CSV data to confirm the format is correct before attempting to upload a lot of lines.

    • Related Articles

    • Manually Importing Transactions

      Important Note:  The easiest and quickest way to track your transactions, especially around the Paycheck Protection Program (PPP) loan forgiveness is to link your bank/credit card accounts. However, if you prefer not to sync your account, the ...
    • Manually Importing Transactions for PPP

      Manually import transactions to track your Paycheck Protection Program (PPP) loan expenses without syncing your bank/credit card account. Written by  Success-Team Updated over a week ago Important Note:  The easiest and quickest way to track your ...
    • A Beginner's Guide to Bank Reconciliation

      A Beginner's Guide to Bank Reconciliation Bank Reconciliation  Bank reconciliation is the process to ensure that your accounting software and your bank account match (equal) on a specific transaction period (usually a month or a year). The goal of ...
    • How to Delete Bank Transactions

      Sometimes you need to remove bank transactions from your list of transactions. This could be because you had a duplicate transaction, a transaction bounced, or it was entered incorrectly. Here is how you can delete a bank transaction in a few simple ...
    • How to Link Your Bank Account

      Lendio's Software Solution can do many accounting tasks for you without being linked to your bank account, the true utility comes when you do make the connection. This enables an automated bookkeeping ledger that stays in sync with your bank account, ...