Short Answer:
You don't.
This does not depend on whether your Treasury Dept has an Account Analysis system or uses MS Excel. It depends on which, the paper statement or EDI 822 file, is the official account of record.
The official account of record means one particular format in which the bank sends your Treasury department's invoice for bank fees due is the only record by which the bank considers "official". For example, if the account of record for your company is the EDI 822 file, then what the paper statement includes or doesn't include is irrelevant because only the data sent via the EDI 822 file is the official record of what your bank says your company owes it in bank fees for that particular time frame.
This is why my short answer to how to balance one to the other is "you don't" because one must serve as the account of record while the other is merely an alternate copy of the same data (ideally). But, hopefully, you are not paying for both!
This is why my short answer to how to balance one to the other is "you don't" because one must serve as the account of record while the other is merely an alternate copy of the same data (ideally). But, hopefully, you are not paying for both!
Let's step back and define what is a Paper Statement...
A paper statement is the either monthly or quarterly often itemized paper invoice (not in an electronic format) companies receive from their bank(s). It includes the account name, account number, account level, any ECR, any Earnings Allowance, list of all balances for the period, list of bank service activity and their fees, total net fees due, etc. This statement tells you what services you've used at what rate and what you owe after any earnings credit is applied. And, either monthly or quarterly, you pay those bank fees due.
Now, what is an EDI 822 file?
The 822 file is the exact same information but in an electronic format so it can be captured by an electronic Account Analysis system. There is nothing you should receive on a paper statement related to your Account Analysis that you can't receive in an 822 file. Ideally, one should be an identical representation of the other. If there is data omitted from the 822 file, then you should contact your bank for a restated 822.
Welcome to an Electronic World!
Despite the notion of an official account of record, this is still a frequently asked question mainly because some Treasury departments consider the paper statement to be their account of record (not sure this is official on their bank's end) so they frantically try to match every single dollar amount/charge seen on the paper statement to what was captured from the EDI 822 file. When a balance/charge does not match, they explain how management will freak out at the discrepancy so an explanation has to be made somehow even if it means manually inputting data where it was not just to balance things.
With the popularity of Account Analysis systems and the EDI 822 file along with the two international BSB formats available; most Treasury departments who have the bank and account size to justify it should only receive an electronic Account Analysis file.
With an electronic system, what purpose does a paper statement really serve? Making the EDI 822 file your account of record alleviates the desire to match one to the other and does hold the bank accountable.
Don't have an Account Analysis system? Then the paper statement will be your only official account of record by default.
With the popularity of Account Analysis systems and the EDI 822 file along with the two international BSB formats available; most Treasury departments who have the bank and account size to justify it should only receive an electronic Account Analysis file.
With an electronic system, what purpose does a paper statement really serve? Making the EDI 822 file your account of record alleviates the desire to match one to the other and does hold the bank accountable.
Don't have an Account Analysis system? Then the paper statement will be your only official account of record by default.
