How do I download my Barclaycard Statement as .CSV?
These instructions are for Barclaycard accounts. For instructions on how to download Barclays statements, click here.
You can download .CSV statements from most credit or business card providers, including Barclaycard. In our experience, Barclaycard doesn't make it easy to find on their online portal.
Find the report
There is a standard report available in the Barclaycard Corporate online servicing portal.
It is called ‘Custom General Transaction Report’.
This report is an Excel version of your statement.
The instructions below explain how to run and schedule this report.
You will need to run/schedule the report for each card.
Standard Reporting
- Sign In to your Barclaycard account (if you are a business Barclaycard customer using this sign-in link;
- To run a report, select the Reports tab;
- Click Run;
- Search for the required report in the search box found under ‘Report Name’ (e.g. Custom General Transaction Report). Alternatively, use the search box;
- Once the report has been selected skip to option 4 – Frequency;
- Choose the option of 'required frequency', and insert a required date range;
- Once options are created click Submit Request.
If scheduling on a monthly basis select ‘Schedule Offset – 1 day’, which means that you will receive the report a day later.
However it will allow the system to ‘catch up’ and produce all required data within the selected date range.
The transactions in the report created don't appear in date order so you may wish to sort the data in the downloaded spreadsheet (by column D, 'FIN.POSTING DATE') before uploading the file.
To better understand the Bank Reconciliation module, please view the module overview video here.