Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Profit and loss
Profit and loss
Hi can anyone tell me how to include your wages and Paye etc in your P&L report? As I do not think that it does it automaticly unless I am wrong?!
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Payroll will appear in the expenditure part of the P&L assuming you have done your payroll journals correctly.
There is a bit about payroll journals here
http://sage.support.makingithappen.co.u ... tm#Payroll
If you can describe where in the nominal you post payments to the tax man and staff then it would be clearer.
My guess is that you are making payments agains the balance sheet accounts and not journalling these to the P&L. If this is the case then you should see large balances accumulating in those balance sheet accounts, if you are doing it as intended then the balannces should be returning to zero as soon as you pay staff and the taxman.
There is a bit about payroll journals here
http://sage.support.makingithappen.co.u ... tm#Payroll
If you can describe where in the nominal you post payments to the tax man and staff then it would be clearer.
My guess is that you are making payments agains the balance sheet accounts and not journalling these to the P&L. If this is the case then you should see large balances accumulating in those balance sheet accounts, if you are doing it as intended then the balannces should be returning to zero as soon as you pay staff and the taxman.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Well that is not so bad.
At least if you have been posting the payments to the right place (ie the balance sheet) and not into the P&L so all you need to do is the journal.
Your P&L will have been wrong, it will missed out the cost of the wages, so you want to get that journal done, before someone spends the profits, they havn't actually made.
At least if you have been posting the payments to the right place (ie the balance sheet) and not into the P&L so all you need to do is the journal.
Your P&L will have been wrong, it will missed out the cost of the wages, so you want to get that journal done, before someone spends the profits, they havn't actually made.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Hi,
Thanks for your reply! I have just done a journal entry and saved it and then went to see if the balance on the p&l was different but it remains the same values?
Also the net wages do appear in the nominal ledger window, (under current liabilities in the credit column, so does this mean that they are being taken into account on the p&l report?
Sorry to go on!!
Many Thanks
Andrea
Thanks for your reply! I have just done a journal entry and saved it and then went to see if the balance on the p&l was different but it remains the same values?
Also the net wages do appear in the nominal ledger window, (under current liabilities in the credit column, so does this mean that they are being taken into account on the p&l report?
Sorry to go on!!
Many Thanks
Andrea
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Keep going on, I would hate to think people give up!!
I think it would be useful if you give more details.
What are the balances of the NI/PAYE & Wages (2210 2211 2220) accounts in the Balance Sheet?
What are the Balances of the Various splits of Employment costs in the P&L (600x 700x)
What was the journal that you did?
I think it would be useful if you give more details.
What are the balances of the NI/PAYE & Wages (2210 2211 2220) accounts in the Balance Sheet?
What are the Balances of the Various splits of Employment costs in the P&L (600x 700x)
What was the journal that you did?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
- brucedenney
- Site Admin
- Posts: 4631
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
It is still unclear what is going on.
You say the journal was a debit to 2220 but you don't say where the credit went.
-----
Normally you would have 3 totals from your payroll
Wages to pay to staff and PAYE/NI to pay to the inland revenue.
The cost of employing your staff is the sum of all three costs.
You would Credit 2220 with the net wages amount, you would Credit the NI/PAYE to 2210/2211 the balance if this would then be a debit against employment costs in the P&L typically 7000
For example Net Pay £100 Tax £10 NI £10 - Total Cost of employment = £120
After running the payroll and doing the journal, the above example would show £20 owing to the Revenue for Tax and NI, £100 owing to staff in net wages and £120 cost of employment in 7000.
The Bank payments to the staff are made against 2220, once they have been made, the balance of that account should be zero, indicating that you have not made any mistakes, over or underpayments.
Similarly when you pay the revenue the balance of the 2210/2211 account(s) will return to zero again confirming that you have not made any mistakes.
-----------
I suspect that you have a been doing the last steps, the bank payments correctly, but that you have not done the original journals.
You say you have no account for Gross Wages 7000 so I suggest you create the account and do all the journals to rectify the situation.
----------
I still don't know what the journal you did was, you will need to give more details to resolve it.
-----------
(If you have Sage payroll you can get it to do the journals for you, you can also get it to split the costs into different nominal codes for different departments and/or types of pay something that is real pain to do by hand)
I don't split NI and PAYE this makes it more simple.
If you are not going to run historical monthly reports, then you can fix this with one journal, otherwise you will need to do a journal for each month.
You say the journal was a debit to 2220 but you don't say where the credit went.
-----
Normally you would have 3 totals from your payroll
Wages to pay to staff and PAYE/NI to pay to the inland revenue.
The cost of employing your staff is the sum of all three costs.
You would Credit 2220 with the net wages amount, you would Credit the NI/PAYE to 2210/2211 the balance if this would then be a debit against employment costs in the P&L typically 7000
For example Net Pay £100 Tax £10 NI £10 - Total Cost of employment = £120
After running the payroll and doing the journal, the above example would show £20 owing to the Revenue for Tax and NI, £100 owing to staff in net wages and £120 cost of employment in 7000.
The Bank payments to the staff are made against 2220, once they have been made, the balance of that account should be zero, indicating that you have not made any mistakes, over or underpayments.
Similarly when you pay the revenue the balance of the 2210/2211 account(s) will return to zero again confirming that you have not made any mistakes.
-----------
I suspect that you have a been doing the last steps, the bank payments correctly, but that you have not done the original journals.
You say you have no account for Gross Wages 7000 so I suggest you create the account and do all the journals to rectify the situation.
----------
I still don't know what the journal you did was, you will need to give more details to resolve it.
-----------
(If you have Sage payroll you can get it to do the journals for you, you can also get it to split the costs into different nominal codes for different departments and/or types of pay something that is real pain to do by hand)
I don't split NI and PAYE this makes it more simple.
If you are not going to run historical monthly reports, then you can fix this with one journal, otherwise you will need to do a journal for each month.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 0 guests