KB Category: Sage 50 Accounts

Sage 50 Accounts

Sage 50 Accounts V28 – Features & Downloads

We’re happy to announce that Sage 50 Accounts v28 and Sage 50cloud Accounts v28 are now available.
You can check your current software version by clicking Help and About in your software.

What’s New in Sage50 Accounts?

  • New Sage Help Centre – Desktop Icon – Read More
  • Maintenance – Automate Check Data – Read More
  • Remote Data Access (RDA – Formerly Sage Drive) Improvements*Read More
  • New ‘Business Dashboards’ Feature*Read More

*Sage50cloud Accounts Only

 

System Requirements for V28:

  • To View System Requirements for V28 – Click Here

 

Downloads:
To Download Sage 50 v28 Full Program Install – Click Here (544mb) [Program Version No: 28.0.226.0]
To Download Sage 50 v28 Data Service Only – Click Here (532mb)

Issues Downloading AccountsMate

There may be issues downloading the AccountsMate installation, these are normally due to browser or computer security settings.

The following may help:

 

Microsoft Edge Browser

The download may be blocked as shown below

 

To release this, click on the 3 dots (…) and select “Keep” and continue as instructed.

 

 

Chrome Browser

Chrome often will not even prompt you about a blocked file. It just seems to do nothing. In this case, try clicking on the 4 dots in the chrome bar to bring up the menu and select “Downloads”

 

This should show the AccountsMate blocked download, click this and the “Windows Protected your PC” screen should appear.

 

 

Other Issues

If you have further problems, try using a different browser. you can copy and paste the download link.

If you can, try disabling your firewall and/or any anti-virus temporarily which may be blocking the download.

Finally, consult with your IT provider and ask them to allow the download.

Sage 50 Version 27.2 Update (VAT ECommerce, MOSS, OSS and IOSS)

Sage 50 Version 27.2 Update (MOSS, OSS and IOSS)

 

If you trade with consumers in the EU from 1st July Sage will have the ability to report the tax.  The update will allow you to report using MOSS, OSS and IOSS.

 

Upgrading your software

Before you begin your Sage 50 cloud Accounts installations there are a few things you should consider.

  • It will require downtime.
  • You need to understand your computer set up.
  • You need to know how your software is set up.
  • If you use 3rd party software, is it compatible with Sage 50cloud Accounts v27? In  preparation of your upgrade the following steps that should be completed, our Sage 50 Checklist can help you ensure these are done in advance.

 

Please contact us on 051-395900 or support@pimbrook.ie if you require a quote to upgrade or if you are on an earlier version of Sage Accounts.

 

Sage have the following knowledge base steps in setting up and processing OSS/IOSS

Additional links

 

Click here for an Introduction to E Commerce, MOSS, OSS and IOSS

 

 

AccountsMate Release – May 2021

Introduction

 

AccountsMate is Pimbrooks enhanced query tool for Sage 50 and is available free of charge as part of our Sage 50 support service, for more details including a demonstration video see this link -> AccountsMate For Sage 50 Overview

A new version of AccountsMate has been released. This is the 2nd release and is another significant update that will allow you to

  • age debtors and creditors by different methods (i.e. due date),
  • look at your sales despatches and purchase deliveries (which is not easy in Sage 50)
  • drill into related data on your products, such as sales, purchases, despatches, deliveries and adjustments.
  • sort your nominal information in “chart of account” order and view by quarter or week (as well as year and month).

The following Highlights section summarises the release features and for more information see the Details section.

 

Highlights

 

The main changes in this release are:

  1. Overview, Customer and Supplier Enquiries improved to allow multiple aged debt methods (e.g. by period, transaction date or due date) and a selected aging date. Also added an Overdue column.
  2. Nominal Data Analysis Enquiry improved by adding Quarter and Week columns.
  3. New Sales Despatch Enquiries – under Sales Order Enquiry to show despatches for a sales order and from the menu to enquire on all Sales Despatches.
  4. New Purchase Delivery Enquiries – under Purchase Order Enquiry to show deliveries for a purchase order and from the menu to enquire on all Purchase Deliveries.
  5. Product Enquiry enhanced to show associated sales, purchase, delivery, despatch and adjustment information.
  6. Nominal Enquiries enhanced to allow sorting of nominal accounts in chart of accounts sequence (i.e. P& L – Sales, Cost, Overheads, etc.).
  7. A number of performance enhancements and fixes (e.g. faster handling of larger data sets)..
  8. Management improvements (e.g. restricting new companies in roles).

 

The following short video shows these -> AccountsMate May 2021 Release

 

 

Details

 

Updating

The new version of AccountsMate will be downloaded automatically the next time a user opens the application,  just accept all questions and the software update will be installed (note, you will have to have administrator permissions for the PC).

 

Versions

To check if you are using the new software, check the versions under Help – About, they should be as follows.

  • AccountsMate Console 1.4.0
  • AccountsMate Plugin 1.7.0

 

Technical List of Changes

AccountsMate Console 1.4.0

 

Role Maintenance
When adding new roles all existing companies are excluded from users by default, they must be manually added via Menu configuration maintenance.

Company Maintenance
Each new company is now excluded by default from existing roles.

General
Change control of System Administrator mode.

 

AccountsMate Plugin 1.7.0

 

Overview/Customer/Supplier Enquiries
Now displays Ageing of the current debt via two new Current/Future columns.
To calculate where the debt resides, Ageing Criteria has been added that calculates it based on Account Terms which is as seen in Sage50 or Due Date or Transaction Date.
Now displays an Overdue column showing values of accumulated unpaid transactions whose due date has passed based on the ageing date.

Customer Sales Orders Enquiry
New Despatch tab added to the details panel that shows despatch details for the Sales order selected.

Customer Transaction Enquiry
Fixed bug where if a large number of transactions where requested it slowed the loading of data into the data grid.

Supplier Transaction Enquiry
Fixed bug where if a large number of transactions where requested it slowed the loading of data into the data grid.

Customer Sales Order Despatch Enquiry
New form created to enquire on Customer Despatches.

Product Enquiry
Now shows associated data for sales/purchase/delivery/despatch/adjustment in a details panel at the bottom of the form.

Supplier Purchase Order Delivery
New form created to enquire on Supplier Deliveries.

Nominal Transactions Enquiry
Sorting on the Category Name/Type/Title columns, the data is sorted as defined by COA sort order.

Nominal Codes Enquiry
Sorting on the Category Name/Type/Title columns, the data is sorted as defined by COA sort order.

Nominal Transaction Analysis
Sorting on the Category Name/Type/Title columns, the data is sorted as defined by COA sort order.
Two new columns Quarter and Week columns have been added that enable the user to review data over those time periods.

General
Fixed bug in all forms where saving a new layout could over writing existing layouts in certain circumstances.
Fixed bug in all forms that displays an account balance, where when the cell is selected the formatting was lost.
Fixed bug in all forms where the columns where not having “Best Fit” applied to detail grids.
Fixed bug in all forms where it was always prompting the user to save layout even if the layout had not been changed.
In all forms with grids, when a column is sorted now makes sure the first grid line is always visible.

AccountsMate Release – March 2021

Highlights

A new version of AccountsMate has been released. This includes the following main changes.

  1. New Nominal Account, Nominal Transaction and Nominal Data Analysis Enquiries (exposes Profit & Loss and Balance Sheet data).
  2. New Customer Quotation Enquiry.
  3. New Customer Invoice & Credit Enquiry.
  4. New Supplier Purchase Order Enquiry.
  5. Customer Transactions Enquiry improved to add name and aging by due date columns.
  6. Supplier Transaction Enquiry improved to add aged by due date column.
  7. Fixes and enhancements to performance (e.g. correct sales profit calculation, multi-company management, more information on license).

 

A video showing these highlights with ideas on how to use them can be seen here -> AccountsMate March 2021 Release Highlights

 

 

Details

 

Updating

The new version will be downloaded automatically the next time a user opens AccountsMate, just accept all questions and the software update will be installed.

 

Versions

To check if you are using the new software, check the versions under Help – About, they should be as follows.

  • AccountsMate Console 1.3.0
  • AccountsMate Plugin 1.5.0

 

Technical List of Changes

AccountsMate Console v1.3.0

 

About Form

  • Now shows the Sage50 version.
  • Only displays single version entry for AccountsMate plugin, rather than by function.

 

Company Change Form

  • To change the existing Company working on no other forms can be open.

 

License Maintenance Form

  • If not an application/organisation administrator, then block access to the form.
  • Form loading speeded up.
  • Can now import license details.
  • Can now copy licenses.
  • Summary added that shows a count of current licenses.
  • When creating an installation string Accounts Type is now defaulted to Sage50
  • Fixed bug where changes to data in property sheet were not being reflected in the grid.
  • Can now filter/sort and export data if in System Administrator mode
  • Fields Account Ref, Type, Reference added.

 

Application Start-up

  • Changed so that if the current license is going to expire in 30 days, indicate if there is a new license that is going to become active or if the software will become un-usable.
  • Message changed when prompting the user if they are Organisation Administrator where one does not exist.

 

General

  • Change system administration mode access.
  • Fixed bug that now clears Menu Security locks for the current user when they enter menu mode.

 

System Options Form

  • Fixed bug where if prompted for administrator password it would still save the details entered even if the user selected ‘Cancel’.

 

User Maintenance Form

  • Fixed bug where a System Administrator could not update the expiry date.
  • Fixed bug where the ‘force logout’ option should only be enabled if System/Organisation Administrator.
  • Fixed bug where changes to data in property sheet were not being reflected in the grid.

 

Company Maintenance Form

  • Fixed bug where an Organisation Administrator could not add/delete Companies.
  • Fixed bug where changes to data in property sheet were not being reflected in the grid.

 

 

AccountsMate Plugin v1.5.0

 

Customer Transactions

  • New fields Aged by Due Date and Aged by Date that based on the due date/transaction date and set to Current, 30, 60, 90 ,120+ for outstanding transactions or ‘Not Aged’ if not outstanding.
  • Customer Name now part of default layout.

 

Quotation Form

  • New form showing Customer quotations.

 

Sales Analysis Form

  • Type criteria now defaults to include credits rather than excluding.
  • New fields Aged by Due Date and Aged by Date that based on the due date/transaction date and set to Current, 30, 60, 90 ,120+ for outstanding transactions or ‘Not Aged’ if not outstanding.
  • Fixed bug where Profit was being calculated incorrectly.

 

Supplier Transactions Form

  • New fields Aged by Due Date and Aged by Date that based on the due date/transaction date and set to Current, 30, 60, 90 ,120+ for outstanding transactions or ‘Not Aged’ if not outstanding.

 

Purchases Analysis Form

  • New fields Aged by Due Date and Aged by Date that based on the due date/transaction date and set to Current, 30, 60, 90 ,120+ for outstanding transactions or ‘Not Aged’ if not outstanding.

 

Nominal Form

  • New function that allows a user to enquire on Nominal account data.

 

Nominal Transaction Form

  • New function that allows a user to enquire on Nominal Transactions.

 

Nominal Data Analysis Form

  • New function that allows a user to analyse Nominal Transactions by COA.

 

Customer Sales Invoices and Credits Form

  • New function that allows a user to enquire on a Customer’s Invoices and Credits

 

Supplier Purchase Order Form

  • New function that allows a user to enquire on a Supplier’s Purchase Orders

 

Initial Installation

  • The installer can now change the Sage50 user/name password at Company level if required when setting up Companies.

 

 

Sage 50 – Standard VAT rate reverts to 23% on 1st March 2021

Standard VAT rate reverts to 23% on 1st March 2021

 

As part of the July 2020 Stimulus Package the Minister for Finance announced a temporary reduction in the standard rate of VAT for a six month period.  On 1 September 2020, the standard rate of VAT was reduced from 23% to 21%. The Minister recently confirmed that the rate will to revert to 23% on 1 March 2021.

In September you created new tax codes to allow for the 21% and now you need to revert back to the 23% codes.:

 

Temp
21% 23% Description
T39         T1 Standard rated sales and purchase of goods for resale
T40        T8 Standard rated purchase of goods from suppliers in EC resale
T41       T24 Standard rated purchase of services from suppliers in EC
T42       T11 Standard rated sales and purchase of goods for non-resale
T43        T18 Standard rated purchase of goods from suppliers in EC non-resale

 

These are Sage Standard Codes but you may have different ones set up on your system.  If these are not your codes then you will need to revert back to your original 23% codes.

 

How to change your Customer/Suppliers and Product Tax Codes using Batch Changes

 

Certain records throughout your system, will refer to your 21% tax codes (eg: Customer Accounts, Supplier Accounts). When the moment is right, you need to change those to refer back to your original 23% codes. The right time to do this would be any time after 28th Feb, and after you have completed processing your remaining 21% transactions. See below for information on how to do this..

You can filter your Customers/Suppliers and Products by ‘Default Tax Code’ as follows:

1. Select Customers

2. Click on Filter and Enter the following filter:

‘Where Default Tax Code is Equal to  T39’-21%

 

3. Click Apply to set the filter

4. Ensure no record is selected – Click Clear

 

5. Click Swap to highlight all your Customers

 

 

4. Click on Batch ChangeDefaults  and change the Tax code (in this example case T1) and  Click Save.

 

Repeat these steps for each tax code, Suppliers and Products.

 

Areas To Consider When Changing VAT Rates 

 

1. Recurring Entries – Sales, Purchase Orders, Invoices and Credits:
  • Ensure you have processed all entries prior to the VAT rate change.
  • Click the relevant list i.e. Invoices, Sales Order or Purchase Order
  • Click New or New Invoice and Recall and then Load.
  • Change the VAT Code, Click OK
  • Memorise again with a different name
    .
2. Recurring Entries – Batch Invoices and Credits:
  • Ensure you have processed all entries prior to the VAT rate change.
  • Click Batch Invoice & Recall the batch.
  • Change the TAX Code.
  • Memorise again with a different name.

 

3. Recurring Entries Bank Transactions:
  • Ensure you have processed all entries prior to the VAT rate change.
  • Click Bank Payments & Receipt’s & Recall.
  • Change VAT Code and click OK.
4. Outstanding Orders & Invoices:

All outstanding invoices and orders may need a VAT code change if not completed before the VAT rate change.

5. Special Product Codes (S1 and S3):

If you use the Special Product Codes S1 or S3 you can amend the default tax code for these by going to Settings, Invoice and Order Defaults, Options and change the Default tax codes in the Specials Items section at the bottom and select OK.

 

6. Other Considerations:
  • 3rd Party software importing records into Sage 50 – need to ensure you are in sync with codes..
  • Any bespoke VAT reports may need to be reviewed.
  • EU related codes for notional VAT.
  • Be mindful of unallocated items when you have two different VAT codes on the account.
  • Sage 50 Irish Vat codes –> see Sage 50 Irish VAT Codes
  • Outstanding SOs or POs will not automatically be updated this must be done manually
  • Changing the default codes for new customers and suppliers.

This can be done in Settings-Customer/Supplier defaults and changed the Std. Tax code back to T1 or whatever Tax code you require to be set for new customers by default.

Brexit & Sage 50

Brexit & Sage 50 – What you need to know!

In this Video Demo we will walk you through:

  • Current Brexit situation and guidelines
  • Who will this affect (i.e. companies trading with or moving goods through UK)
  • How can Sage 50 help:
    • New release Brexit features & upgrade options
    • Work arounds without upgrading

For further information on Brexit and Sage 50, please view our Knowledge Base article:

Brexit & Sage 50 Webinar Recording

 

Processing the workaround in Sage 50 for Versions 27.0 and below

Processing the workaround in Sage 50 for Versions 27.0 and below

Sales Transactions

Sales invoices can be continued to be processed in the same manor as before selling goods to the UK will now be treated as a non EC country and will use the tax code T14.

Selling goods to Northern Ireland will continue to be treated as a EU Sale and will use the code T4 for goods and T22 for Services

 

1st January 2021

  • Complete 2020 Intrastat and VIES
  • Country Codes
    • Remove the UK from the EU in Settings
    • Enter NI and GB before VAT codes for northern Ireland customers and suppliers
    • If you are trading under the northern Ireland protocol you need to do this in company details.

 

Create Tax Codes

Use the next available 12 tax codes in sequence. Create them the same as the existing tax code in the Replica column.

 

Set up Accounts for Contra postings

  • Contra Customer – CONC01
  • Contra Supplier – CONS01
  • Contra Bank – 1210

Versions prior to 27.1 will not create an automatic credit for the postponed accounting VAT.  To facilitate in doing this manually we need to create a new Contra account for Customer, Supplier and Bank.

These accounts can be used for recording of postponed VAT for all UK and rest of word suppliers.  These accounts should always have a 0 balance after transactions are posted and allocated.

Additional Setup

  • EORI number
  • Commodity codes
  • Amend Records for UK Customers, UK Suppliers and products that have Default Tax Codes
  •  Customers and Suppliers in the UK to have a default tax code for postponed accounting to T40
  • Incomplete orders and invoices/credits – change tax codes to include.

Processing in Sage 50 V27.0 and below

Net + VAT – Goods and import VAT

Step 1: Post separate purchase invoices for the NET and VAT, as follows:

 

Type Net T/C VAT
PI – Purchase invoice

(CONS01)

Zero T39 – T50 Import VAT amount
SI – Sales invoice (CONC01) Zero T39 – T50 Import VAT amount
PI – Purchase invoice

(UK SUPPLIER)

Goods net amount T39 – T50 Zero

 

Step 2:  Post a payment (PP) and a receipt (SR) for the VAT component to the Contra Bank Account (1210) as below:

Type Net T/C VAT
Zero T9 – Standard rate Import VAT amount
PP – allocate to purchase invoices (CONS01)
Zero T9 – Standard rate Import VAT amount
SR – allocate to sales invoice (CONC01)

 

Enter in Purchase Invoice

Enter the UK/ ROW supplier invoice-net only (remember to remove the VAT)

 

 

Enter in VAT only Purchase Invoice

Enter the Contra VAT amount against CONS01 (contra account you just set up for Suppliers VAT)

 

 

Balance on Suppliers account

As you can see the balance on the supplier account is the net value and the VAT is showing separately in your Contra account CONS01.

 

 

Contra Sales Invoice VAT only amount

Enter you Contra Sales Invoice VAT only amount

 

 

Supplier Payment to The Contra A/C CONS01

 

 

 

Customer Receipt to The Contra A/C CONC01

 

 

 

Accounts show Zero

All accounts show zero after allocations are done.

 

 

 

 

 

 

 

 

 

 

Build and maintained by Modus.