Convert Barclaycard card statements to Xero.
Checked against the printed balances first.

1. 1Log in to Barclays Online Banking; personal Barclaycards are serviced there now rather than on a separate Barclaycard site.
2. 2Click the Profile icon, choose "Manage documents and messages", then "Statements and documents".
3. 3Select the Barclaycard account and the statement month; up to seven years of statements are listed for personal cards.
4. 4Open the statement and save it as a PDF from the viewer.
5. 5In the Barclaycard app (or the Barclays app if your card has moved across), go to "Statements and documents", pick the card and month and tap the download icon; on Android the file lands in the My files folder.
6. 6Business cardholders use Barclaycard business online servicing, where "Statements" holds up to thirteen months and a separate transaction report download covers longer periods.

Then drop the file above. Several months at once is fine; each statement comes back as its own .csv file.

Barclaycard does not lock the statements you download from Barclays Online Banking or the app. We have not met a protected Barclaycard PDF; if one turns up, the upload box asks for the password and unlocks it in your browser before anything is sent.

Barclaycard marks credits with a CR suffix rather than a minus sign, the usual cause of a reversed column; the conversion reads CR as a credit, so the Xero CSV has payments positive and purchases negative. The check runs from the previous balance on page one to the new balance before Xero sees the file.

Barclaycard's help page says statements and transactions can be downloaded "in a range of formats" from Statements and documents, and in practice the transaction export on a card account mirrors the Barclays current account one: CSV, OFX or QIF for a date range you have searched. The online transaction view for a personal card reaches back about twelve months, so a longer history means the statement PDFs regardless. Business servicing is more fragmented: online servicing lists thirteen months of statements, the CentreSuite portal used for some commercial programmes shows six months of statements and twelve of transactions, and the reporting platform for larger programmes holds thirty-six months of data. None of these exports carries the previous balance, the interest split by balance type or the new balance, so a month cannot be proved from them. The monthly statement PDF has all three, back to seven years on personal cards.

1. 1Drop the statement on the home page and confirm the balance check is green.
2. 2Click Xero.
3. 3In Xero: Accounting → Bank accounts → the account → Manage Account → Import a Statement.
4. 4Upload the CSV. Xero recognises the columns; confirm and import.
5. 5Reconcile as usual. The statement balance in Xero should match the printed closing balance.

• Credits are marked with a CR suffix, not a minus, so a plain number extraction reads a payment as a purchase; the previous-to-new balance check fails at once and the swap fixes the sign.
• Personal Barclaycards are now serviced inside Barclays Online Banking, so the statement list sits under the Barclays profile menu rather than on a separate Barclaycard site.
• Purchase and balance transfer balances are itemised separately, each with its own interest line; every interest line is a debit in the check like any other fee.
• Xero's importer is strict about date format and stops on the first bad row; ours uses the format Xero documents.
• Positive/negative convention: Xero wants money out negative. Bank PDFs print it positive in a "Withdrawals" column. We convert.
• Missing statements create reconciliation gaps for years. Convert a whole year at once and the batch Summary shows which months balanced.

None of this is bank-specific configuration. The balance check catches these cases for every bank; this list just explains what you will see on a Barclaycard file.