KB Category: Sage 50 Accounts

Sage 50 Accounts

How to post a payment on account in Sage 50

How to post a payment on account in Sage 50

 

If you received  payment from a customer or you wish to make a payment to a supplier before the invoice has been entered, you can post a payment on account and allocate it at a later date to an invoice.

 

How to enter a Payment on Account for a Supplier:

1. There are two ways to make supplier payment in Sage, one is to open up the Bank account module, select the required bank acount and click on ‘Supplier Payment’ or the other way is to open up the Suppliers module and and click on the  ‘Supplier Payment’  icon on the top menu bar.

2. On the Supplier Payment screen, ensure that the correct bank is selected and from the ‘Payee’ drop down select the supplier that your making the payment to. Ensure that the correct date has been entered and in the amount box enter in the suppliers payment amount.

 

3.  When you’ve entered the correct details click ‘Save’.  Because you have not selected an invoice to allocate the payment to, Sage will warn you that the amount entered is an unallocated amount and it will ask if you wish to post a Payment on Account

 

4. Click ‘Yes’ to post the payment on account.  The payment on account will be seen on the supplier ‘Activity’ as outstanding and will remain that way until you allocate it to an invoice.

 

 

 

How to enter a payment on account for a customer:

1. Like the supplier payment there are two ways to enter a customer payment on account.  This can be done via the Bank module or in the Customer module by selecting the icon ‘Customer Receipt’.  On the Customer Receipt screen select the correct Bank and customers account, ensure that you have entered in the correct date and amount, you can add a reference if required.

 

2. Click ‘Save’ on the ‘Customers Receipt’ screen.  Just like the Supplier payment on account you will get a similar message asking if you wish to post a Payment on Account.  Select ‘Yes’ to save.  This unallocated payment can be seen on your customers ‘Activity’ screen as Outstanding and will remain so until you allocate it to an invoice.

 

 

 

 

 

Sage 50 Accounts Version 25 System Requirements

Sage 50 Accounts Version 25 System Requirements

 

Supported Operating Systems

All 32-bit or 64-bit variants of the following operating systems:
Note: Please ensure all the latest Microsoft Service Packs and Updates are installed.

  • Windows 10 (except Windows 10S)
  • Windows 8.1
  • Windows 8
  • Windows 7
  • Windows Server 2019 (except Windows Server 2019 Essentials)
  • Windows Server 2016 (except Windows Server 2016 Essentials)
  • Windows Server 2012 (except Windows Server 2012 Essentials)
  • Windows Server 2012 R2 (except Windows Server 2012 R2 Essentials)
  • Windows Server 2008 (not supported on Small Business Server/SBS 2008)
  • Windows Server 2008 R2 (not supported on Small Business Server/SBS 2008)

Microsoft Small Business Server (SBS) 2008 and 2011 – due to a small number of customers seeing performance issues we don’t recommend the use of Microsoft Small Business Server (SBS) 2011 or 2008 with Sage Accounts v25. The installation of Sage Accounts v25 on SBS is blocked by default but, if required, you can still install the software by following the steps in article 32387. For further information on SBS 2011, please refer to article 30792 .

Sage Accounts is not tested on virtual environments, for example, Hyper-V servers. We therefore can’t guarantee Sage Accounts will install and work correctly on these environments.

Storing Sage Accounts data on non Windows operating systems, for example NAS drives, is not tested and therefore not supported.
Although most Sage software must be installed on a Windows operating system, you may still be able to use our software by installing Bootcamp on your Apple Mac computer, please refer to article 15524.

We do not support any issues you might have using these operating systems.

Minimum Hardware Requirements
  • 2 GB RAM (4 GB RAM if running a 64-bit operating system).
  • 2GHz processor or higher.
  • 5GB of free disk space.
  • 1Gbps network (100mbps minimum).
  • Screen resolution between 1024 x 768 and 1920 x 1080 – this applies to 4k and hi-res monitors.
  • Maximum DPI setting of 125%

Sage Accounts v25 requires you to install the Sage Data Service on the machine where your data is held. If this isn’t possible, you won’t be able to share your data on that machine. Although not supported, previous versions may have worked as they didn’t use the Sage Data Service. For more information on storing your data on non-Windows operating systems

Office Integration

Some features of Sage 50 Accounts interact with and require an installation of Microsoft Office.
These features include:

  • Emailing invoices and reports
  • Exporting report and screen lists to excel

Sage 50 Accounts v25 is compatible with the following:

  • Office 64-bit versions – In Sage Accounts v25 you can use the File > Microsoft Integration > Contents to Microsoft Excel feature and also run Excel ODBC queries with Office 64-bit. Other features aren’t compatible.
  • Office 365 32-bit – desktop version only
    To check if it’s the desktop version, Control Panel > Program > Default Programs > Set your default programs > check if Microsoft Outlook is the desktop version.
  • Office 2016 32-bit edition
  • Office 2013 32-bit edition
  • Office 2010 32-bit edition (except Office 2010 32-bit starter edition)

Sage 50cloud Accounts only
Sage 50cloud Accounts offers additional functionality using Office 365. These features require a UK based Microsoft Office 365 Business Premium or Enterprise E1, E3, or E5 subscription. Initial setup must be done by a user with global admin rights and a supported licence. If you’re unsure if you meet these requirements, please contact your Microsoft Office 365 supplier.

The section below confirms the requirements for each element of Sage 50cloud Accounts:

Sage 50cloud Intelligence

  • Excel desktop edition 2013 or 2016
  • Excel online

Sage Contact

  • Outlook desktop edition 2013 or 2016
  • Outlook online (accessed via browser)
    Sage Contact does not currently support the native mobile applications for mobile devices.

Further information:
Microsoft Office 365 system requirements
Microsoft Office compatibility

Microsoft Office 2007 and 2010 are no longer supported by Microsoft, therefore we’re limited in the support we can offer. We can help with basic steps, however if these don’t work, you should upgrade your software to a more recent version.

* Not compatible with Office 2010 32-bit starter edition

Sage 50c Accounts only

Sage 50c Accounts offers additional functionality using Office 365. These features require an Office 365 Business Premium subscription.

The section below confirms the requirements for each element of Sage 50c Accounts:
For further information about Microsoft Office compatibility, please refer to article 32017

Internet Connection

A broadband Internet connection is essential to keep your Sage software up to date, and to take full advantage of features such as Sage Drive and synchronising data with Office 365.

  • Recommended minimum download speed: 4Mbps
  • Recommended minimum upload speed: 2Mbps
Antivirus Software

To optimise performance your antivirus software should be configured to exclude Sage files from its checking routines

Internet Browser

Internet Explorer version 11 or above.
To check, open Internet Explorer, select Tools then choose About Internet Explorer.

Microsoft .Net

Microsoft .NET Framework 4.6 is required.

Sage Capture app

Sage Capture is tested on the following operating systems, but may work with earlier versions:

  • iPhone 5 or above running iOS 9.3 or later.
  • Android 5.0 (Lollipop) and above.

 

 

Migration from (Software) to Sage 50 – Checklist

Migration from (Software) to Sage 50-Checklist

 

Install Software – Checks

  1. Check Regional Settings are correct
  2. Anti Virus Software
  3. UAC Turned Off
  4. Install and Configure Software
  5. Ensure Tax codes are Correct (Irish Settings)
  6. Is Foreign trader required to be activated
  7. Have they any UK companies – activate MTD
  8. E-banking set up
  9. Set up email for basic layouts
  10. Set financial year

Software Migrating from (Software)

  1. Export Stock records and opening stocktake if needed. (Import to Sage 50 section as well)
  2. Get copy of P&L and B/S as well as the TB (could get extra paid job creating new COA at very least)..I know this COA is in your Checks section
  3. Agree mapping of Trial Balance with client from existing Nominal codes to Sage 50 codes and Enter to Sage 50.

 

Software migrating from (Software)

  1. Export Customers from (Software)
  2. Export Suppliers from (Software)
  3. Export Nominal from Sage one
  4. Report on outstanding transactions in the Bank
  5. Export Opening balances for Customers
  6. Export Opening balances for Suppliers
  7. –
  8. Export Trial Balance

 

Sage 50

  1. Import Customers to Sage 50
  2. Import Suppliers to Sage 50
  3. Import Nominal to Sage 50
  4. Enter outstanding Bank transactions
  5. Import/Enter Opening balances for Customers
  6. Import/Enter Opening balances for Suppliers
    1. Do Journal to cancel out he suspense account entries after entering the opening balance
  7. Enter Trial Balance

 

Checks
  • Cross check that everything Balances
  • Configure COA
  • Report Design

How to reduce Purchase Order Qtys to equal what has been received: Order Changes to COMPLETE

How to reduce Purchase Order Qtys to equal what has been received: Order Changes to COMPLETE

 

Scenario Example: A Purchase Order is created for eg:100 items.  The supplier may send only 95. When 95 are received into the system, the order is left as ‘PART’ received. The other 5 will never be received, as the supplier has no more.

In the scenario above, ideally you would be able to reduce down the original Qty on the Purchase Order, to make it equal to the Qty received. You can do this by following the instructions below:

  1. Highlight the Purchase Order.
  2. Click ‘Amend Deliveries’ button.
  3. Click ‘Off Order’ button & then close the order.
  4. The order will now appear as ‘CANCEL’.
  5. Open the order.
  6. A message box will appear which reads: ‘Amending this purchase order will cause the order to be placed on order. Do you wish to continue?’
  7. Click Yes to the message.
  8. On the relevant line(s), edit the Qty in the line detail, by either clicking directly into the Qty field or by clicking on the arrow in the Description field and editing the Qty in the window that pops up. Set the Qty to be equal to the Qty already received.
  9. Click Save & then close the order.

If Qtys on the whole order are now fulfilled, the order will now appear as ‘COMPLETE.

 

How to add total average days to pay to the Time Taken To Pay Sales Invoices report and the Time Taken To Pay Purchase Invoices report

How to add total average days to pay to the Time Taken To Pay Sales Invoices report and the Time Taken To Pay Purchase Invoices report

 

The following two reports show how long it’s taken for an invoice to be paid and calculates the average number of days taken to pay per customer or supplier.

  • Customers > Reports > Credit control reports > Time Taken To Pay Sales Invoices report.
  • Suppliers > Reports > Credit control reports > Time Taken To Pay Purchase Invoices report.

A common request is to add a total to these reports to show the average number of days taken to pay across all invoices. This article takes you through how to add a total for the average days to pay invoices on the Time Taken To Pay Sales Invoices report and also the Time Taken To Pay Purchase Invoices report as the method is the same.

 

Open the report in Sage Report Designer

 

1. Customers or Suppliers > Reports > Credit control reports.

2. Select the required report > Edit.

 

Add the average total

 

1. ACCOUNT_REF Footer > right-click the expression Average_Days_To_Pay > Copy > Report Footer > right-click > Paste.

2. Properties pane > Reset Section > check that Report Footer is selected.

 

 

Save the report

1. Report menu > Report Properties > enter a new report name and description > OK.

Report Designer v1.3 and below – Report Explorer pane > select report name at the top > Properties pane > Name > enter a new report name > Enter.

 You can check your Report Designer version in Help > About > Application > File Version. 

2. File > Save As > select correct folder > File name > enter a new file name > Save.

3. File > Exit.

 

 

 

 

 

 

Issue: Error when entering a correct username & password

 

Issue: Error when entering a correct username & password

 

Entering a correct username & password gives the following error message: ‘The Password you have entered has not been recognised.’

Sage may say that this is a .NET issue but after long investigation on call ref 65-109867 this proved wrong.

Take a copy of the data and put it into your own version to see if it reacts the same. If it does then the data is corrupt and must be restored from a clean backup. Restore the data to  a local drive and copy the resulting ACCDATA folder to the correct location.

Entering the Correct Password gives:

The Password you have entered has not been recognised

 

 

Entering the incorrect password normally gives:

You have entered an invalid password

SAGE STANDARD VAT CODES – PURCHASE AND SALES OF GOODS TO EU

SAGE STANDARD VAT CODES – PURCHASE AND SALES OF GOODS TO EU
Transaction Type Goods/Services Sale/Resale Sage Tax Code to Use Description
SALES TO EU CUSTOMERS GOODS N/A T4 Sales of goods to VAT registered customers in EU
  SERVICES N/A T22 Sales of services to VAT registered customers in EU
PURCHASE FROM EU SUPPLIERS  GOODS RESALE T5 Exempt –  rated purchase of goods from suppliers in EU
      T7 Zero –  rated purchase of goods from suppliers in EU
      T8 Standard –  rated purchase of goods from suppliers in EU
      T25 Reduced –  rated purchase of goods from suppliers in EU
    T29 Second Reduced –  rated purchase of goods from suppliers in EU
PURCHASE FROM EU SUPPLIERS  GOODS  NON RESALE T15 Exempt –  rated purchase of goods from suppliers in EU
      T17 Zero –  rated purchase of goods from suppliers in EU
      T18 Standard –  rated purchase of goods from suppliers in EU
    T26 Reduced –  rated purchase of goods from suppliers in EU
      T30 Second Reduced –  rated purchase of goods from suppliers in EU
PURCHASE FROM EU SUPPLIERS  SERVICES   T23 Zero –  rated purchase of services from suppliers in EU
      T24 Standard –  rated purchase of services from suppliers in EU
      T25 Reduced –  rated purchase of services from suppliers in EU

 

Tax codes in Sage Accounts – Ireland only

Tax codes in Sage Accounts – Ireland only

Sage Accounts calculates VAT using tax codes. Each tax code has a rate associated with it and the VAT calculates based on this rate.To save you time when posting transactions, you can use the default tax codes already set up in your software. You can edit any of these tax codes or you can add your own.

There are 100 tax codes in total, and for each one you can amend the rate and description. You can also specify if it’s an Irish or EU tax code, and choose if you want to include it in your VAT Return.

Before you proceed any further, check that your computer’s regional settings is set to Ireland and not UK. For more information about how to do this, please refer to article 33741.

 

Sage default tax codes

 

T0 Zero rated sales and purchase of goods for resale.  

T1 Standard rated sales and purchase of goods for resale. Currently 23%.  

T2 Exempt sales and purchase of goods for resale.
T3 Reduced rate sales and purchase of goods for resale. Currently 13.5%.
T4 Sales of goods to VAT registered customers in EU.  

T5 Exempt import of goods from suppliers in EU.
T6 Exempt import of goods from suppliers outside EU.  

T7 Zero rated purchases of goods from suppliers in EU.  

T8 Standard rated purchases of goods from suppliers in EU.  

T9 Non-vatable tax code.

Note: If you post any transactions with this tax code, they don’t appear on your VAT Return.

 

T10 Zero rated purchase of goods for non-resale.  

T11 Standard rated purchase of goods for non-resale.  

T12 Exempt purchase of goods for non-resale.  

T13 Reduced rated purchase of goods for non-resale.  

T14 Zero rated export of goods to customers outside EU.  

T15 Exempt import of goods from suppliers in EU.  

T16 Exempt import of goods from suppliers outside EU.  

T17 Zero rated purchases of goods from suppliers in EU.  

T18 Standard rated purchases of goods from suppliers in EU.  

T19 Zero rated purchases of goods from suppliers outside EU.  

T20 Reverse charges.  

T21 Zero rated purchases of goods from suppliers outside EU.  

T22 Sales of services to VAT registered customers in EU.  

T23 Zero rated purchases of services from suppliers in EU.  

T24 Standard rated purchases of services from suppliers in EU.  

T25 Reduced rated purchases of goods from suppliers in EU.  

T26 Reduced rated purchases of goods from suppliers in EU.  

If you’ve installed the September 2016 Improvements for Sage 50 Accounts, the following additional tax codes are set up by default:
T27 Second reduced rate sales/purchase of goods for resale  

T28 Second reduced rate sales/purchase of goods for non-resale  

T29 Second reduced rated purchases of goods from EC suppliers  

T30 Second reduced rated purchases of goods from EC suppliers  

T31 Livestock rate sales and purchase of goods for resale  

T32 Livestock rate sales and purchase of goods for non-resale  

T33 Livestock rated purchases of goods from EC suppliers  

T34 Livestock rated purchases of goods from EC suppliers  

T35 Flat rate compensation sales/purchase of goods for resale  

T36 Flat rate compensation sales/purchase of goods non-resale  

T37 Flat rate compensation purchases of goods from EC suppliers  

T38 Flat rate compensation purchases of goods from EC suppliers  

Which boxes the tax codes affect on the VAT Return

 

Tax code T23 appears correctly on the VAT Return, however we’re currently investigating an issue where T23 transactions appear in the wrong box on the Return of Trading Details (RTD). Read more >

Tax Code Sale or Purchase Net or VAT amount Box
T0 Sale Net Appears in Total value of sales, excluding VAT box
VAT N/A
Purchase Net Appears in Total value of purchases, excluding VAT box
VAT N/A
T1 Sale Net Appears in Total value of sales, excluding VAT box
VAT Appears in box T1 and VAT charged on supplies of Goods and Services box
Purchase Net Appears in Total value of purchases, excluding VAT box
VAT Appears in box T2
T2 Sales Net Appears in Total value of sales, excluding VAT box
VAT N/A
Purchase Net Appears in Total value of purchases, excluding VAT box
VAT N/A
T3 Sales Net Appears in Total value of sales, excluding VAT box
VAT Appears in box T1 and VAT charged on supplies of Goods and Services box
Purchase Net Appears in Total value of purchases, excluding VAT box
VAT Appears in box T2
T4 Sales Net Appears in box E1 and Total value of sales, excluding VAT box
VAT N/A
T5 Purchases Net Appears in box E2 and Total value of purchases, excluding VAT box
VAT N/A
T6 Purchases Net Appears in Total value of purchases, excluding VAT box
VAT N/A
T7 Purchases Net Appears in box E2 and Total value of purchases, excluding VAT box
VAT N/A
T8 Purchases Net Appears in box E2 and Total value of purchases, excluding VAT box
VAT Appears in boxes T1 and T2 and VAT due on intra-EU acquisitions box
T9 Non-vatable tax code, doesn’t appear on VAT return.
T10 Purchases Net Appears in Total value of purchases, excluding VAT box
VAT N/A
T11 Purchases Net Appears in Total value of purchases, excluding VAT box
VAT Appears in box T2
T12 Purchases Net Appears in Total value of purchases, excluding VAT box
VAT N/A
T13 Purchases Net Appears in Total value of purchases, excluding VAT box
VAT Appears in box T2
T14 Sales Net Appears in Total value of sales, excluding VAT box
VAT N/A
T15 Purchases Net Appears in box E2 and Total value of purchases, excluding VAT box
VAT N/A
T16 Purchases Net Appears in Total value of purchases, excluding VAT box
VAT N/A
T17 Purchases Net Appears in box E2 and Total value of purchases, excluding VAT box
VAT N/A
T18 Purchases Net Appears in box E2 and Total value of purchases, excluding VAT box
VAT Appears in boxes T1 and T2 and VAT due on intra-EU acquisitions box
T19 Purchases Net Appears in Total value of purchases, excluding VAT box
VAT N/A
T20 Purchases Net Appears in Total value of purchases, excluding VAT box
VAT Appears in boxes T1 and T2 and VAT charged on supplies of Goods & Services box
T21 Purchases Net Appears in Total value of purchases, excluding VAT box
VAT N/A
T22 Sales Net Appears in box ES1 and Total value of sales, excluding VAT
VAT N/A
T23 Purchases Net Appears in box ES2 and Total value of purchases, excluding VAT
VAT N/A
T24 Purchases Net Appears in box ES2, Total value of sales, excluding VAT and Total value of purchases, excluding VAT
VAT Appears in boxes T1 and T2 and VAT charged on supplies of Goods & Services box
T25 Purchases Net Appears in box E2 and Total value of purchases, excluding VAT box
VAT Appears in boxes T1 and T2 and VAT due on intra-EU acquisitions box
T26 Purchases Net Appears in box E2 and Total value of purchases, excluding VAT box
VAT Appears in boxes T1 and T2 and VAT due on intra-EU acquisitions box
T27 Sales Net Appears in Total value of sales, excluding VAT box
VAT Appears in box T1 and VAT charged on supplies of Goods and Services box
Purchases Net Appears in Total value of purchases, excluding VAT box
VAT Appears in box T2
T28 Sales Net Appears in Total value of sales, excluding VAT box
VAT Appears in box T1 and VAT charged on supplies of Goods and Services box
Purchases Net Appears in Total value of purchases, excluding VAT box
VAT Appears in box T2
T29 Purchases Net Appears in box ES2 and Total value of purchases, excluding VAT
VAT Appears in boxes T2 and VAT due on intra-EU acquisitions
T30 Purchases Net Appears in box ES2 and Total value of purchases, excluding VAT
VAT Appears in boxes T2 and VAT due on intra-EU acquisitions
T31 Sales Net Appears in Total value of sales, excluding VAT box
VAT Appears in box T1 and VAT charged on supplies of Goods and Services box
Purchases Net Appears in Total value of purchases, excluding VAT box
VAT Appears in box T2
T32 Sales Net Appears in Total value of sales, excluding VAT box
VAT Appears in box T1 and VAT charged on supplies of Goods and Services box
Purchases Net Appears in Total value of purchases, excluding VAT box
VAT Appears in box T2
T33 Purchases Net Appears in box ES2 and Total value of purchases, excluding VAT
VAT Appears in boxes T2 and VAT due on intra-EU acquisitions
T34 Purchases Net Appears in box ES2 and Total value of purchases, excluding VAT
VAT Appears in boxes T2 and VAT due on intra-EU acquisitions
T35 Sales Net Appears in Total value of sales, excluding VAT box
VAT Appears in box T1 and VAT charged on supplies of Goods and Services box
Purchases Net Appears in Total value of purchases, excluding VAT box
VAT Appears in box T2
T36 Sales Net Appears in Total value of sales, excluding VAT box
VAT Appears in box T1 and VAT charged on supplies of Goods and Services box
Purchases Net Appears in Total value of purchases, excluding VAT box
VAT Appears in box T2
T37 Purchases Net Appears in box ES2 and Total value of purchases, excluding VAT
VAT Appears in boxes T2 and VAT due on intra-EU acquisitions
T38 Purchases Net Appears in box ES2 and Total value of purchases, excluding VAT
VAT Appears in boxes T2 and VAT due on intra-EU acquisitions

Popular goods and services and the tax codes to use

T0 Zero rated goods and services.
  • Most foods.
  • Children’s clothing.
  • Books and newspapers.
  • Construction of new housing.
  • Passenger transport.
  • Medicines on prescription.
T2 Exempt goods and services.
  • Some land and building sales.
  • Some finance charges.
  • Education and some training.
  • Health.
  • Betting and gaming.
  • Burials and cremation.
  • Postal services.
  • Insurance.
T9 Non-vatable items.
  • Wages.
  • Bank or cash transfers.
  • Capital.
  • Loans, dividends and gifts of money.

To create or amend a tax code

  1. Click Settings, click Configuration, then click Tax Codes.
  2. Select the required tax code then click Edit.
  3. Complete the Edit Tax Code window as follows:
Rate Enter the required percentage. For example, to set up a 23% VAT rate, enter 23.00.

If you select the Enable EC Code check box, the Rate box isn’t active.

Include in VAT return To include transactions with this tax code on the VAT Return, select this check box.
Reverse Charge To flag sale or purchase items that fall under the remit of carousel fraud, for example, mobile phones, select this check box. Don’t select this for standard reverse charge transactions.
Resale To flag transactions involving purchases for resale, select this check box.
Outside EC or Non EC Transactions To flag transactions that occur outside EU territories, select this check box.
Enable EC Code or EC code If this is an EU tax code, select this check box. Then choose the relevant options from the drop-down lists.
Link To This option is only available for EU purchase tax codes.If you want to use this tax code to record notional VAT, choose the required tax code that you want to link to. Notional VAT calculates based on the rate of the code you link to.
Rate For RTD reporting purposes, select the relevant option.
Description Enter a description for the tax code.
  1. Click OK, then click Apply.
  2. click Close and if you’re prompted to save the changes, click Yes.