Accounts

Memorise Journals

Is there a journal or journals you need to enter every month such as a month end accounting journals or a salary journal.  If you have entries that you post regularly you can use the Memorise and Recall options to save you time and prevent mistakes

Memorise the Journal

1. Nominal Codes > Journal entry
2. Enter the information as normal into your journal, but before you click Save, click ‘Memorise’.
3. Filename* – enter a file name.
4. Description – enter a description of the journal eg Monthly Wages
5. Click Save.

Recall Journal

1. Click Recall.
2. Scroll down the list of saved journals till you find the one you want then click Load.
3. You can the date, amend the Reference or department or details, change a nominal code or a debit or credit.
4. You can add or delete lines by using F7 to insert a line and F8 to delete a line.

Memo: remember the journal must balance before you can save it.

Editing Memorised Journals

You can edit memorised journals if the information is changing on a permanent basis.

1. Click Recall.
2. Scroll down the list of saved journals till you find the one you want then to make the changes to and make a note of the exact file name, then click Load.
3. Amend the journal as required, then click ‘Memorise’.
4. Use the same file name as noted in point 2.
5. Click yes to the message ‘Overwrite Contents’ and your changes will be saved.

Memo: If you have got ‘Copy skeleton journal values’ ticked in ‘Company Preferences’ > ‘Parameters’ you can save the Debits and Credits on your memorised journal.

If you would like help setting up memorised journals or need any other help with your Sage Accounts, please contact us

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