Payroll

Show alternative row colours on your employee list

To make things easier when you are working with a large list of employees in Sage 50 Payroll, you can add alternative colours to the employee list.

Set Alternative row colours

1. Click View, then click Options.
2. Click the Colours
3. Ensure the Ignore colours check box is blank.
4. Next to Alternative Employee Lines, click the second icon
5. Select a basic colour.

TIP: Or, to add a custom colour, click Define Custom Colours, then Add to Custom Colours

6. Click OK

If you need help setting up alternative row colours or need any other help or advice with your payroll please contact us

We can also provide a remote access service where we can directly link into your computer to help you resolve your Sage Accounts or Payroll problems.

Accounts  

Supplier Batch Invoice or Credit Note

A Supplier batch invoice or credit note is a simple way to record a purchase or a credit note from a supplier.

1. Click Suppliers and then click Batch invoice or Batch Credit.
2. Enter the details as follows:-

A/C*  – enter the supplier’s account reference.

Date* – enter the date of the supplier invoice/credit.

Due On*  – This is the date the invoice payment is due for payment and is based on the terms you have agreed with your supplier and is set up in the credit control area of their record.  If you have not set up terms this will be by default set at 30 days.

Ref/ Credit No – You can enter the supplier’s invoice number or credit note number or your own reference number.  This is the reference which will appear on your reports.

Ex. Ref – An additional reference option.  This does not appear on a lot of the reports.

N/C* – The default nominal code per the supplier’s record appears, if needed you can change this, just typing in a new code or press F4 and click the relevant code.

Department* – enter the correct department number if departments are being used.

Project Ref and Cost Code – To allocate this invoice or credit note to a project, enter the relevant project reference and cost code.

Details – Enter any additional details.  TIP as you type, the ActiveSearch Popup finds the closest match and displays them in a popup list for you to choose from.

Net – Enter the net amount of the invoice or credit note.

To calculate the net amount from the gross amount, enter the gross amount then press F9, Sage 50 Accounts calculates the net and VAT amount using the tax code in the T/C box.

T/C – The default tax code from the supplier record automatically appears, this can be changed if required.  If more than one tax code is required, simply enter multiple lines.

VAT – This is the amount of the VAT calculated, based on the tax code and the net amount, this can be amended if required so it matches what is on the supplier’s invoice.

Gross – This shows the gross amount of the invoice or credit note and is calculated automatically.

Disputed? – If the supplier invoice is disputed, you can choose a dispute reason in the Disputed? column.

Amount Paid – Invoices only – if you want you can enter the amount you want to pay, you can also enter part payments if required.

Pay Date  – Invoices only – enter the date you want to pay the invoice(s).

Bank A/C – Invoices only – Your default bank account appears.  If you need to change this either type in the code of the bank account you want or click the arrow and then double-click the required bank account.

Pay Ref –  Invoices only – Enter a reference for the payment or when using e-payments, to make the transaction appear as an e-payment, enter (BACS) as the Pay Ref.

3. Click Save

You can either save after each entry or carry on to the next line and choose a different supplier.

If you would like help entering supplier batch invoices or credit notes or need any other help with your Sage Accounts please contact us

Accounts

Customer Batch Invoice or Credit Note

A Customer batch invoice or credit note is a simple way to record a sale or a credit if you don’t need to print an invoice or credit note or update stock.

1. Click Customers and then click Batch invoice or Batch Credit.
2. Enter the details as follows:-

A/C*  – enter the customer’s account reference.

Date* – enter the date of the invoice/credit.

Due On*  – This is the date the invoice payment is due and is based on the terms you have agreed with your customer and set up in the credit control area of their record.  If you have not set up terms this will be by default set at 30 days.

Ref/ Credit No – You can enter an invoice number or credit note number here if you want to.  This is the reference which will appear on your reports.  Using different references on reports prevents transactions for the same date and the same customer grouping together.

Ex. Ref – An Additional reference option.  This does not appear on a lot of the reports.

N/C* – The default nominal code per the customer record appears, if needed you change this, just typing in a new code or press F4 and click the relevant code.

Department* – enter the correct department number if departments are being used.

Project Ref and Cost Code – To allocate this invoice or credit note to a project, enter the relevant project reference and cost code.

Details – Enter any additional details.  TIP as you type, the ActiveSearch Popup finds the closest match and displays them in a popup list for you to choose from.

Net – Enter the net amount of the invoice or credit note.

To calculate the net amount from the gross amount, enter the gross amount then press F9, Sage 50 Accounts calculates the net and VAT amount using the tax code in the T/C box.

T/C – The default tax code from the customer record automatically appears, this can be changed if required.  If more than one tax code is required, simply enter multiple lines.

VAT – This is the amount of the VAT calculated, based on the tax code and  the net amount, this can be amended if required.

Gross – This shows the gross amount of the invoice or credit note.

Amount Paid – Invoices only – if you want you can enter the amount already paid, you can also enter part payments if required.

Pay Date  – Invoices only – enter the date the money was received.

Bank A/C – Invoices only – Your default bank account appears.  If you need to change this either type in the code of the bank account you want or click the arrow and then double-click the required bank account.

Pay Ref –  Invoices only – Enter a reference for the payment or when using e-payments, to make the transaction appear as an e-payment, enter (BACS) as the Pay Ref.

3. Click Save

You can either save after each entry or carry on to the next line and choose a different customer.

If you would like help entering customer batch invoices or credit notes or need any other help with your Sage Accounts please contact us

Payroll 

Print and check the P32 Employer Payment Record

It is a good idea as we are now half way through the tax year to check what you have paid to HMRC agrees to your P32 for the last 6 months, so any over or under payments can be corrected in a timely fashion.

Printing the P32 Employer Payment Record.

1. Click Reports the click Period End.
2. Select Form P32-Employer Payment Record then click Print.
3. Enter the required tax month range eg month 1 to 6, then click OK, OK.
4. Ensure your printer detail are correct then OK then click Close.

You have now successfully printed the P32 for the first 6 months of the Tax year.  You should now check the information on the P32 report against the payments you have made to HMRC, check that there are no under or over payments, if there are these can be corrected with your next month’s payment.

If you need help printing your P32 report and/or checking your payments against your P32 report or need any other help or advice with your payroll please contact us

We can also provide a remote access service where we can directly link into your computer to help you resolve your Sage Accounts or Payroll problems.

Accounts

Record a one-off Sale

Use a bank receipt to record your money received in Sage 50 accounts without creating a customer record.

EXAMPE: A one off sale, the banking of cash sales or bank interest received etc.

Use a bank receipt to record your money received in Sage 50 Accounts without creating a customer record.

1. Click Bank accounts.
2. Select the account you want to receive the money into.
3. Click Bank receipt.
4. a) Bank * – check you have selected the correct bank account. TAB
5. b) Date * – enter the date of the transaction. TAB
6. c) Ref – you can enter a reference if required eg Paying in slip number or cash sale number. TAB
7. d) Ex. Ref – you can enter an additional reference if required here or leave blank. TAB
8. e) N/C * – Enter the relevant Nominal Code. TAB
9. f) Department * – enter the relevant department if you are using departments. TAB
10. g) Project Ref – select the relevant Project if required. TAB
11. h) Details – enter some details about the transactions. TAB
12. i) Net – enter the net amount, if you do not know the net amount you can enter the gross amount and click Calculate net (F9). TAB
13. j) T/C* – select the correct VAT code. TAB
14. k) Tax – check that the VAT has been calculated correctly, if not amend as required. TAB
15. You can either click Save or carry on with the next line.

Memo if a sale is for more than one item eg they are for different types of sales and/or have different rates of Tax, just split the transaction over two lines using the same date and reference but different nominal codes and/or different VAT Codes, just make sure that the Total at the top agrees to the total of the receipt when you have finished.

If you would like help entering bank receipts or need any other help with your Sage Accounts please contact us

Accounts

There are times you need to record one off payments, such as a payment of bank interest or purchases from petty cash.

Bank Payments

1. Click Bank accounts.
2. Select the account to make the payment from
3. Click Bank payment.
4. a) Bank * – check you have selected the correct bank account or select the account you require. TAB
5. b) Date * – enter the date of the transaction. TAB
6. c) Ref – you can enter a reference if required eg cheque number or petty cash voucher. TAB
7. d) Ex. Ref – you can enter an additional reference if required or leave blank. TAB
8. e) N/C * – Enter the relevant Nominal Code. TAB
9. f) Department * – enter the relevant department or just click across. TAB
10. g) Project Ref – select the relevant Project if required. TAB
11. h) Cost Code* – select the relevant cost code if required. TAB
12. i) Details – enter some details about the transactions. TAB
13. j) Net – enter the net amount, if you do not know the net amount you can enter the gross amount and click Calculate net (F9). TAB
14. k) T/C* – select the correct VAT code. TAB
15. l) Tax – check that the VAT has been calculated correctly, if not amend as required. TAB
16. m) Gross – this is calculated automatically and you can just use it to check the amount is correct.
17. You can either click Save or carry on with the next line.

Memo if a transaction is made up of more than one item eg you have been to the supermarket and purchased tea and coffee together with A4 paper you might want to split these items to sundries and stationery, just split the transaction over two lines using the same date and reference but different nominal codes, amounts and tax codes, just make sure that the Gross total at the bottom agrees to the total of the receipt when you have finished.

If you would like help entering one off payments or need any other help with your Sage Accounts please contact us