Profit & Loss Account Does Not Correspond to Sales and Purchases

Hi,

I’m looking to send my profit and loss accounts to the banks for funding, however I’m so confused by them.

I just want to show all the money has come in and out of the business over the last couple of months and thought the P&L would do this?

However, the sales seem to missing VAT but I take this is meant to happen?

More, importantly the figures for expenditure seem to be way off. For example, I have paid suppliers for stock and it clearly shows in purchases on the dashboard and is listed as a transaction on the bank statements page but I can’t find anywhere in the Profit and Loss account.

Any help would be appreciated? If I just want to see a summary of money in and out of the business is there an easier report for this?

Thanks,

Darrell

P&L figures will not show VAT as this is an asset/liability.

Also P&L calculations are based on invoices (accrual) rather that actual monies paid/received.

Is there a report in Quick File that I can use for what I need?

Also, have I entered the debits incorrectly if they do not show in the P&L?

I really need a way around this.

A P&L would be what you would normally issue to a prospective lender to show a company’s profitability. Reporting on the cash position doesn’t provide an accurate picture as you’re including things like VAT which belong on the balance sheet.

One thing I did see on your accounts is a significant volume of purchases posted to “Stock” this is a balance sheet code and won’t feature on the P&L. If you’re holding stock long term then it’s fine to post it here but if it is being actively disposed of then you’d need to journal it to closing stock or general purchases so it then features on the P&L.

Ok great, I think that is the problem I have listed purchases as ‘Stock’ and they should be in ‘General Purchases’.

Is there an easy way I can change the purchases posted as ‘Stock’ to ‘General Purchases’?

Ok I’ve got it now. Will change the purchase tag and stop using the asset tags. Thanks for your help Glenn, by the way your system is great!

1 Like

This topic was automatically closed after 32 hours. New replies are no longer allowed.