To manually add bank statement lines in Xero, you have two routes. Create the transaction in the account and use Mark as Reconciled, which makes Xero add a statement line for it. Or build a tiny CSV with just the missing lines and import it. For one or two lines either works. For more, import a file.
Can you type bank statement lines straight into Xero?
Xero's help articles describe no screen for typing a bank statement line from scratch. Statement lines come from a feed, an imported file, or from Xero itself when you mark an account transaction as reconciled. So "adding a line by hand" means either marking a transaction as reconciled or importing a small file you made yourself.
Xero's page on manually importing bank statements points to both. If a feed is missing transactions from before it started, it suggests importing them. If only a few transactions are missing, it says you can create the account transactions and mark them as reconciled instead.
The two routes leave different traces:
| Route | What Xero records | Best for |
|---|---|---|
| Mark as Reconciled | A statement line with User as its source | One or two lines you cannot get from the bank |
| Small import file | Ordinary imported statement lines | Anything you can copy from a statement |
Mark as Reconciled and the User statement line Xero creates
Mark as Reconciled takes an account transaction you entered in Xero, such as a spend money or receive money entry, and reconciles it without a matching line from the bank. Xero creates a new bank statement line to reconcile it against. That line shows User as its source on the Bank statements tab.
Xero's guide to manually marking a transaction as reconciled warns that you should only do this when you cannot import the original line from the bank, by feed or by file. The steps:
- Make sure the account transaction exists. Create a spend money or receive money transaction if it does not.
- In the Accounting menu, select Bank accounts, then click the account.
- Open the Account Transactions tab.
- Select the transaction you want to reconcile.
- Click More, then Mark as Reconciled, and confirm.
You can also open the transaction itself, click Options and choose Mark as Reconciled. Either way the transaction's status changes to Reconciled, and a statement line made by Xero appears. Only users with the administrator role, or the standard role with bank accounts access, can do this.
A two-line import file for missing Xero statement lines
A small CSV with only the missing lines gives Xero real statement lines, the same as a full statement would. Copy the date, amount and payee from the bank statement into a file with a header row, then import it into the account through Import a Statement.
A worked example
These values are an example. A dog-grooming business finds two lines from its March statement missing in Xero after a partial import:
Date,Amount,Payee,Description,Reference
03/14/2026,-42.75,Paws Supply Co,Shampoo and towels,
03/21/2026,315.00,Hilltop Kennels,Grooming invoice,INV 588
Import it through the account's Import a Statement option, match the columns, and complete the import. The steps for the full route are in importing a bank statement into Xero step by step.
After the import, the statement balance in Xero on March 31 should equal the bank's closing balance. If it does, the two lines were all that was missing.
Where the missing lines came from
Lines usually go missing because an import was split badly, a PDF page was skipped, or a feed started a day late. If the lines are missing because a scan could not be read, the guide to importing a scanned bank statement into Xero covers the checks to make first. Card accounts are similar: importing an Amex statement into Xero covers the sign conventions to watch when you rebuild card lines.
Why is a small import file safer than marking a whole month reconciled in Xero?
A small import file records what the bank did, while Mark as Reconciled records what you entered and asks Xero to trust it. For one or two lines, the difference is small. For a whole month, every typing mistake becomes part of the statement balance, and there is no bank line to show the error.
Three reasons favour a file for anything more than a couple of lines:
- Errors stay visible. An imported line with the wrong amount fails to match its transaction, and you notice. A transaction marked as reconciled has nothing to disagree with.
- The audit trail is cleaner. Imported lines look like any other bank data. Many User lines in one month invite questions at year end.
- The real line can still arrive. A feed or a later full import can bring in the same transactions, which creates duplicates.
When not to add lines by hand at all
Do not add a whole month by hand when you have the statement, even as a PDF. Convert it instead. SimpleBankConvert is being built to turn a PDF statement into a CSV that Xero's statement import accepts, so the month goes in as bank data. You can get on the list for access.
Duplicate User statement lines once the real Xero import arrives
The mistake that follows a manual fix is the duplicate. If you mark a transaction as reconciled and later the bank's real line arrives by feed or file, Xero now holds two statement lines for one payment. The statement balance in Xero then stops matching your online banking.
To find and fix it:
- Open the account's Bank statements tab.
- Look for pairs of lines with the same date and amount, one with User as the source.
- Delete the line that shows User. Keep the line from the bank.
- Check that the statement balance now matches the bank's balance for that date.
Xero's Bank Reconciliation Summary report helps spot duplicate statement lines, and the Account Transactions report shows duplicate transactions. Run one of them after any month where you added lines by hand.
Fixing transactions after they land is a different job in QuickBooks Online, covered in editing imported transactions in QuickBooks Online, if you also keep books there.