Skip to content
logo Knowledgebase

Formatting CSV bank statements

Created on  | Last modified on 

Summary

How to format CSV bank statements to import into Sage Accounting.

Resolution

Layout

  1. Enter the headings, Date, Description and Amount into row 1.
  2. Ensure you put the information per transaction into the correct column.
  3. A payment shows as a negative, a receipt shows as a positive.

    Layout of 3 columns, with headings in row 1.

Formatting your date

  1. Select Column A and right click.
  2. Select Format cells and select the Number tab.
  3. Click Custom and select General.
  4. Enter dd/mm/yyyy or yyyy/mm/dd or mm/dd/yyyy depending on your setup.
  5. Click OK.

Separating the data onto multiple columns

  1. Highlight the whole column and click Data.
  2. Select Text to Columns.

    Example of all the text in column A.

  3. Select Delimited and click Next.
    • Delimiters are the characters separating the fields
  4. Select the delimiter separating the fields and click Next.
    • For example, a comma or double apostrophe "
  5. A preview will display, click Finish.
  6. Remove any columns you don't need then click File.
  7. Select Save As and ensure you save the file as a comma delimited (CSV)

Related Solutions