This interface won't let me upload any images (sorry!) so here is an example of my excel checks sheet. Note in our Chart of Accounts account 50400 what we put in the Number field is Construction Material Costs, 60400 is Bank Service Charge, etc. Whatever is in your Account column must EXACTLY match the number you've put in the number field when you made that account or when you paste it, it will turn red and error out. Whatever is in your Payee field must EXACTLY match your Payee/Vendor name or it will error out.
My credit/deposit sheet looks similar.
| Date | Amount | Number | Memo | Payee | Account |
| 9/16/2020 | 1208.69 | 113 | CHECK 113 REF. NO. [removed] | | 80000 |
| 9/17/2020 | 3603.07 | | 8674 Debit Card Purchase Jaeger Lumber- Middles 908-6860070 NJ | Jaeger Lumber | 50400 |
| 9/17/2020 | 105.91 | | 8674 Debit Card Purchase Jaeger Lumber- Middles 908-6860070 NJ | Jaeger Lumber | 50400 |
| 9/17/2020 | 258.37 | | 8674 Debit Card Purchase Jaeger Lumber- Middles 908-6860070 NJ | Jaeger Lumber | 50400 |
| 9/17/2020 | 36 | | Overdraft Item Fee | | 60400 |
