Scroll

Importing the Bank Statements

Bank Statement lists all the transactions occurred in a particular bank account. If your financial institution is not listed in SlickPie, you can add it manually and instead of getting automatic feeds through Link Bank, you have to manually import the statement.

 

Please note Most banks allow downloading transactions for previous 1-3 months only. To get the accurate account balance, make sure you have entered a correct closing balance of your bank account as an Opening Balance in SlickPie.

 

 

Step 1: Download Bank Statement

To import bank statement in SlickPie, you need to download your bank statement in CSV (Comma Separated File) or OFX (Microsoft Money) format. Most banks support both the formats. If the statements are not in CSV or OFX, you can use SlickPie Sample File to create one and modify it accordingly.

 

Please note If you are on Mac and using Excel to edit your CSV, please use 'Windows Comma Separated'  (.csv) option.

 

 

1. Go to Accounts and click Bank Accounts.

 

 

 

 

2. Select the Bank Account you are downloading the statement and click Manage Account.

 

3. Go to Statements and select Bank Statements.

 

 

 

4. Click Import.

 

 

 

 

 

Step 2: Arrange the data in CSV file

Before importing the file in SlickPie, you need to arrange the data in CSV file downloaded from the bank. There are 2 scenarios as per the format available through a bank:

Scenario 1: If downloaded CSV file consists single column for the amount.

Scenario 2: If downloaded CSV file consists double columns for the amount.

 

Please note You have to match the headers in CSV file to be able to import the files successfully into SlickPie. Files can't be imported till the headers are matched as shown in the sample file.

 

 

Scenario 1: CSV file with a single column for the amount that is both debits and credits are shown in one column.

 

1. Give the following headings to the downloaded CSV File.

 

  • Date
  • Type
  • Description
  • Amount

 

 

 

2. With single amount field, the downloaded file should look something like below.

 

 

Please note

  • Date and Amount are the mandatory fields and cannot be left blank.
  • Amount field will accept only decimal and no comma or currency sign.

 

3. Once the single column sheet is downloaded, save the sheet so you can import it later.

 

 

Scenario 2: CSV file with two columns, Debit and Credit, instead of one single column.

 

 

1. Give the following headings to the downloaded CSV File.

  • Date
  • Type
  • Description
  • Debit
  • Credit

 

 

 

2. With double amount fields, the downloaded file should look something like below.

 

 

 

Please note

  • Date, Debit, and Credit are mandatory fields and cannot be left blank.
  • Debit and Credit will accept only decimal and no comma or currency sign.

 

3. Once the double column sheet is downloaded, Save the sheet to import it in your SlickPie account. 

 

 

Step 3: Import CSV file in SlickPie

After formatting/ preparing the data in CSV file, you can import it in your SlickPie account.

 

1. Follow Steps 1-3 as mentioned above in Download Bank Statement in CSV file.

 

2. Click Import.

 

 

 

3. Click Upload Your File.

 

 

 

 

4. After selecting the file, click Next.

 

 

 

 

5. Verify the selected Date Format or select one as in your CSV file.

 

 

 

6. Match your File Headers with that of SlickPie's.

 

 

 

7. Once the headers are matched, click Next.

 

 

 

8. On the next page, Import the File, you will see the list of transactions as was in your CSV file. Verify the records downloaded and edit if needed.

 

 

9. Once all the entries are verified, click Import.

 

 

 

10. Once the data is imported, you will see the success message.

 

 

11. The imported transactions can be viewed in Bank Statements.

 

 

 

Please note the imported transactions are unreconciled.

 

 

Bank Reconciliation

Once the statement is downloaded you can reconcile data with the transactions as entered in SlickPie. Visit Bank Reconciliation to learn how to reconcile the records.

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk