Tips

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

  1. 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.

  1. 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

Please note that this update is not compatible with Excel Integrated Reporting (EIR) or Sage 50 HR Data Synchronisation.

An email will be released soon letting you know when it is available for download, if you need help with downloading it and installing it or if you need any other help 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.

  1. 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.

Not all accountants are grey.

Call us now for your FREE consultation on 01691 654545 or click here...