The first step of the accounting workflow is to import your bank statement containing the list of transactions from your bank. This step will allow you to receipt into Street any money you've received into your bank as well as reconcile those transactions in one smooth process. You'll also be able to reconcile any outgoing payments in your bank with the existing outgoing payments in Street.

If you'd prefer, you can watch our Streetwise Training video that covers both Importing Bank Statements & Reconciling Transactions in Street.

To get started, you need to import your bank statement. Head to the Bank Accounts tab within Accounting on the left side panel and click 'Import Statement'. If you have multiple accounts, for example a client account and a deposit account, make sure you click import statement on the correct account.

The first step is to select your bank statement file and upload it from your computer. Please note, the bank statement file must be in CSV format.

The next step of importing is to assign the imported fields to the corresponding fields within Street. Essentially, you're telling Street what data each column in your bank statement contains. The import page is split into two sections.

The left hand side contains the data from your bank statement, showing the first row of the file (typically the column headers depending on your bank's format) and follow by the second row (typical the first line of data) so you can clearly see what data is in each column. Using this information, you should choose the associated field in Street to 'assign to' that column in your bank statement.

When assigning fields there are three mandatory fields that must be setup: Date, Amount and either Reference or Description. All other fields are optional however it is highly recommend to assign as many fields as possible to improve the speed and accuracy of reconciliation.

With the Amount field, Street has three options and the one/s you choose will depend on how your bank statement is laid out. If your bank statement has a single column with both positive amounts (incoming money) and negative amounts (outgoing money), you should use "Amount" field to assign to. If you bank files has two separate columns, one for incoming and one for outgoing money, you should use the "Amount (Credit)" and "Amount (Debit)" fields to assign to.

Below the assign fields section you need to select the correct date format by checking your bank statement and seeing how the date format is laid out. Ie if you see 18/02/2026 then choose the date format DD/MM/YYYY in Street.

Finally, you have the option to not import the first line of the bank statement file. In most cases, your bank statement will have column headings (date, amount, reference etc). In this case, ensure you tick the 'Don't import first line of the file (column headings)' button so Street doesn't try and use the first row of column headers as data to import.

Additionally, you'll see the option to choose how many header rows to skip. This is useful if your bank statement has more than one row of headers / information, before actually showing the relevant data.

It's not very common but if your statement doesn't have any headers, ie the very frist row in your statement is actual data, you should untick this toggle so the first line is imported.

On the right hand side you can see a breakdown of what data will show based on the fields you've assigned. The aim is to ensure that the three mandatory fields of date, amount and reference or description are all ticked green, meaning the data has been assigned correctly. Any additional green ticks will help for reconciliation later.

If you see any red exclamation marks, this indicates some of the data is either invalid or has not been assigned. Common mistakes here are the date format selected doesn't match the format in your bank statement or mandatory fields have not been assigned. In this case you should review the assigning fields step and ensure everything is setup correctly.

In the below example, the date field is invalid as the date format doesn't match the date value from the statement. And the reference and description fields are flagged as neither have been assigned.

Once you're confident that the fields are assigned correctly you can click 'save and continue' to proceed to the final step.

The final stage of importing a statement is to review the statement lines. You will see an Import Status section with three categories: Valid, Duplicates and Errors.

Ideally everything will be valid as that means there are no errors and you can proceed with the import.

If you have any Duplicates that means that a specific transaction from your bank statement has been imported previously. In this case, you should review your statement compared to the transactions already in Street to ensure you're not importing data previously imported.

You can do this from the Bank Transactions section, accessed from the three dot menu on the bank account page.

From here you can see all previously imported bank lines and compare to the one you are attempting to upload to see why there are duplicates flagging.

If you have any Errors that means something has gone wrong with the data on your import. Typically this can be things like £ signs or commas in the spreadsheet which cannot be read by Street and will prevent you from importing. In this case, review your spreadsheet and reach out to Street Support via live chat if you need further help.

Below the status header you will see a list of every transaction that's been imported, formatted based on the assigned fields, along with their individual status.

You can use the checkboxes to choose which transactions to import, allowing you to ignore duplicates or even specific transactions lines if you don't want them included for any reason.

When you are confident with the data on screen, you can finalise the import by clicking 'Confirm Import'.

You'll then be taken to the Reconcile page where you can begin the process of receipting and reconciling any transactions from your bank. For more information on this step, see our Reconciling and Receipting help article.