Example report (made-up numbers)
Month: September 2026
Checks to make next

1. The books and bank totals differ, and the files do not yet show why.
Amount to check: -$125.00
Your books show $250.00 going out across the entries in books.iif rows 4 and 7. Your bank file shows $125.00 going out (bank.csv row 2). Your books show $125.00 more going out than your bank does. Adding up the books entries does not show which ones go with the bank row.
Rows: books.iif rows 4 and 7; bank.csv row 2
Next: Ask your bookkeeper to check the original entries and the bank records listed here. What explains the difference? Do not add an adjustment just to make these totals agree.

2. The $125.00 on your bank statement and the $125.00 in PayPal may be the same payment, but the files cannot prove it.
Your bank shows a withdrawal of $125.00 on Sep 10, 2026 (bank.csv row 2). PayPal shows $125.00 coming into your PayPal balance on Sep 10, 2026 (payment-company.csv row 7). The amount and date match. Your bank shows money going out and PayPal shows money coming in. That fits money moved from your bank to PayPal. It does not fit a PayPal payout to your bank. Neither file shows a reference number that ties these rows together, so the files alone can't prove this is the same payment.
Rows: bank.csv row 2; payment-company.csv row 7
Next: Find the PayPal Transaction ID for this transfer (the reference number PayPal gives it) and look for the same number on your bank statement.

3. The transfer may have been entered twice in the books. The original records must confirm it.
More than one group of transfer entries in the books has the same date, accounts, amount and direction. This does not show that money moved twice.
Rows: books.iif rows 4, 5, 7 and 8
Next: Ask your bookkeeper to check the entry reference numbers and original records for each group. Do entries in both connected accounts describe the same transfer? Confirm that before deleting anything.

Before you rely on this: A matching amount or date is a clue, not proof. Only a matching reference number shows that two rows are the same payment. Your bookkeeper or accountant decides how to record anything listed here. This report compares only the files you uploaded. It does not change your books or give accounting, tax or legal advice.

Source appendix
Files checked:
File 1 (PayPal): File could be read; original records still need checking. Dates found: Sep 10, 2026.
File 2 (bank): File could be read; original records still need checking. Dates found: Sep 10, 2026.
File 3 (books): File could be read; original records still need checking. Dates found: Sep 10, 2026.
Check the difference between the books and bank [Source: books.iif / row 4 / columns "ACCNT", "DATE", "AMOUNT", "TRNSTYPE"; books.iif / row 7 / columns "ACCNT", "DATE", "AMOUNT", "TRNSTYPE"; bank.csv / row 2 / columns "Date", "Amount"]
Check the transfer reference number [Source: bank.csv / row 2 / columns "Date", "Amount"; payment-company.csv / row 7 / columns "Record type", "Gross  amount", "Total fees net billed", "Net  amount ", "Related record ID"]
Check whether the transfer was entered twice [Source: books.iif / row 4 / columns "TRNSTYPE", "DATE", "ACCNT", "AMOUNT"; books.iif / row 5 / columns "TRNSTYPE", "DATE", "ACCNT", "AMOUNT"; books.iif / row 7 / columns "TRNSTYPE", "DATE", "ACCNT", "AMOUNT"; books.iif / row 8 / columns "TRNSTYPE", "DATE", "ACCNT", "AMOUNT"]
Net amount in these rows: $125.00 [Source: payment-company.csv / row 7 / columns "Record type", "Gross  amount", "Total fees net billed", "Net  amount ", "Related record ID"]
Total balance left and available in the payment account: $125.00 [Source: payment-company.csv / row 5 / columns "Balance ", "Available", "Withheld", "Total"; payment-company.csv / row 4 / columns "Balance ", "Available", "Withheld", "Total"]
Other money added to the payment account: $125.00 [Source: payment-company.csv / row 7 / columns "Record type", "Gross  amount", "Total fees net billed", "Net  amount ", "Related record ID"]
Bank-account entries in your books: -$250.00 [Source: books.iif / row 4 / columns "ACCNT", "DATE", "AMOUNT", "TRNSTYPE"; books.iif / row 7 / columns "ACCNT", "DATE", "AMOUNT", "TRNSTYPE"]
Difference between the books and bank: -$125.00 [Source: books.iif / row 4 / columns "ACCNT", "DATE", "AMOUNT", "TRNSTYPE"; books.iif / row 7 / columns "ACCNT", "DATE", "AMOUNT", "TRNSTYPE"; bank.csv / row 2 / columns "Date", "Amount"]