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.
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)
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.
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.
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.
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:
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.
Nominal Data Analysis Enquiry improved by adding Quarter and Week columns.
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.
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.
Product Enquiry enhanced to show associated sales, purchase, delivery, despatch and adjustment information.
Nominal Enquiries enhanced to allow sorting of nominal accounts in chart of accounts sequence (i.e. P& L – Sales, Cost, Overheads, etc.).
A number of performance enhancements and fixes (e.g. faster handling of larger data sets)..
Management improvements (e.g. restricting new companies in roles).
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.
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.
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 Change – Defaults 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.
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.
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.
