Gap between the bank and your sheet
What it's for You paste the bank and your sheet, and it shows where they differ and which line is missing.
Example reply
Today's match Bank: 1,250 Your sheet: 1,180
The prompt (copy it and paste it into your assistant)
I am going to paste what follows. You paste the bank and your sheet, and it shows where they differ and which line is missing. Do not invent facts. Do not move money or give financial advice. Do not post entries. Do not move money. Do not file taxes. Answer in this order: 1. Subtract the sheet from the bank and keep the gap 2. Find that amount on only one side 3. Write it on the side where it is missing and subtract again Here it is: [paste this here: The bank balance]
The bank balance and the one on your sheet do not match, and you end up hunting for the gap by eye.
How to use it
- Press Copy, or the button for the app you use.
- Paste the text into the chat.
- Write what you need, with your own details. For example:The bank says 1,250 and my sheet says 1,180. Today there was a transfer of 70 to the hardware store. It is on the bank side and not on my sheet. Everything else matches.
Note: it does not move your money or replace the person who keeps the books.
You write
The bank says 1,250 and my sheet says 1,180. Today there was a transfer of 70 to the hardware store. It is on the bank side and not on my sheet. Everything else matches.
You get back
Today's match Bank: 1,250 Your sheet: 1,180 Gap: 70 The transfer of 70 to the hardware store is on the bank and not on the sheet. Write it on the sheet, with the store's name. Once you write it, both sides sit at 1,250. If they do not, there is another transaction. Do not invent it: look line by line.
In three steps
- Subtract the sheet from the bank and keep the gap.
- Find that amount on only one side.
- Write it on the side where it is missing and subtract again.
A tip 70 is a transfer, not a rounding. It goes in with a name.