I'm playing around with some figures (for practice) and have got myself stuck.
I have created a cash book in excel, with both cash and bank columns and then the analysis columns. The figures are predominately cash (no credit sales) with only two or three payment entries that are direct from the bank (one paid at purchase by cheque and one credit supplier).
I have used contra entries to show cash deposited into the bank (bank column in the receipts side, cash column on the payments side) as this saves the need for a cash and bank account elsewhere in the ledger (am I right?)
I know that the analysis columns, when cross-cast, should equal the cash and bank totals minus opening balances, but in my case it does not when the contra entries are in place. Am I not meant to include contra entries in the cross-casting checks? All my figures equal their respective analysis entries, but of course the contra entries have no entries in the analysis columns.
What doesn't help is that the only workbook example I have that shows an analysed cash book with both cash and bank columns using contra entries, has errors in the figures between the diagram and explanation so when I cross-cast the diagram myself, even that doesn't add up.
Confused is putting it lightly! What am I missing?
-- Edited by Loulabell on Saturday 3rd of October 2015 02:48:42 PM
I cannot visualise what you are saying. As these are only practice files you could copy and paste into paint, save it and then post as an attachment so that people can see what you mean. (assuming that these are just made up figures).
__________________
Shaun
Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.
I borrowed the figures from some old files (with permission) I had access to via my voluntary work. They were "raw figures" really basic, no double entry or anything. Thought they would be good to play with and use for practice (the more you do something the more it sinks in etc).
I used 3 months worth of figures before balancing as there were so few, plus there was a cash deposit to the bank right at the start of the calendar year before any sales were made.
I've copied into paint as requested and have attached it.
I think I've done everything right on there, it's just the cross-casting checks that I can't make sense of with the contra entries.
-- Edited by Loulabell on Saturday 3rd of October 2015 03:41:27 PM
Only a quick observation as I'm just going out . The other exp analysis doesn't seem to match the totals correctly. There seems to be an extra £110 of wages.
Just having a quickie look at this... it appears to me that, if you are going to include a £1145 cash receipt to the bank, you need an analysis column on the receipt side called "cash into bank".
And, if you are going to show that as a payment out of cash, you need to have a "cash out to bank" column on the payments side. Then when you add your analysis columns up, they should equal the same as the cash and bank payments column added together.
Just lookin at what Anne mentioned, and you have missed out a line for £110 wages on the cash/bank column, then everything else from that, in those columns, is one cell up
so when I cross-cast the diagram myself, even that doesn't add up. 
