Bank Balances - Record and Reconcile using Excel Spreadsheets

[@ashachase2010]

Your videos have been of great help to me, so thank you. But this one has a mix-up around timestamp 7:13. The narrator says = +I2+J2+K2, but it's actually +H3+J3+K3 like what's being typed into the spreadsheet. No?

[@MrSpreadSheet]

Hi, Why not download the file, you can then check your work against the original. Just follow the guide set out in the video :-)

[@raptorscrest9239]

Yes, But look at his screen... It actually says I, even though I ran on to the same problem. Just moved the H2 and H3 to the I, just as they have it. It will fix that mix up.

[@user-xo8nx2vx9p]

Hi, when attempting to copy the formula from the Receipts column (J3) into (K5) the payments column and updating the "Receipts" to "Payments" within the formula, the result i get is zero rather than the -215.
The formula only works when "receipt" is within the formula and not "payment". I would say im rather good with excel however this problem has me stumped. Your assitance would be greatly appreciated.

[@MrSpreadSheet]

Hi, Why not download the file, you can then check your work against the original. Downloads are available at www.MrSpreadSheet.com :-)

[@raptorscrest9239]

Hi, I had the same issue. I then Filled D7 With "Payment" and Magic! Hope it helps

[@chimbakatongo6649]

Hi, did you finally get it? I'm getting 0 aswell

[@raptorscrest9239]

Yes, But look at his screen... It actually says I, even though I ran on to the same problem. Just moved the H2 and H3 to the I, just as they have it. It will fix that mix up@@chimbakatongo6649

[@user-xo8nx2vx9p]

@@raptorscrest9239 - thanks, that worked wonders!!

[@patriciadarling3242]

Would it be possible to incorporate credit cards also for reconciliation?

[@MrSpreadSheet]

Yes, our 'Paid For' products incorporate 4 Bank/Card Accounts :-)