Balance sheet woes
brownem
Registered Posts: 4
Hello, I think I have gone a bit number blind so was hoping for some advice. I have just completed an excel spreadsheet year end accounts and my balance sheet is out by £11000. This was the net value of a purchase made in December, it was an "in and out" purchase, so did not sit on stock, and has been included in the P&L as part of cost of sales. Why then is my balance sheet showing as being out by this amount? If I add it into stock, it balances, but as previously mentioned, it's not a stock item? I have gone back through the accounts to make sure everything has been included where necessary, and now feel that I am just going round in circles. Help please?
0
Comments
-
What core records are you working from? If your balance sheet doesn't balance you've got a one-sided entry (or a misbalanced entry) somewhere...0
-
Thank you for your post. The core records comprise of simple income & expenses worksheets, summary sheets which lists the months totals (all of which tally) asset register, debtors & creditors (again, all of which reconcile), the details of which are then transferred onto the P&L and balance sheet. Everything else balances with the exception of this one entry which has gone in as an expense on the expenses sheet and as a creditor on the creditors sheet, and then under cost of sales on the P&L. This is a spreadsheet template that I have used many times before without any issues which is why I am now wondering am I missing the obvious?0
-
If in and out, it is in as a purchase but should also be recorded in sales?0
-
In that case has it not been debited twice?brownem said:Everything else balances with the exception of this one entry which has gone in as an expense on the expenses sheet and as a creditor on the creditors sheet, and then under cost of sales on the P&L.
0 -
What Mike said - sounds like it's in the P&L twice (expenses and CoS).0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership