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.
Calculate the manual figures for your VAT Return and RTD – Brexit (ROI)
To make it easier for you we have created a report to help you calculate the figures you need to add to the VAT Return and RTD.
To download and install
Backup your Sage 50
Click Download on the report backup from here. The file either automatically saves to your Downloads folder or you are prompted to save the file.
If prompted to save the file, browse to where you want to save it, for example, the Windows desktop, then click Save.
Open Sage Accounts, on the menu bar click File, then click Restore.
Click ;Browse, browse to where you saved the file, then double-click the file – postponed-brexit.001.
Below ;Description of data to be restored, check that it shows the following: Report/Layout download
Backup of: – Report files
To install the report, click OK .When a message appears advising you are about to overwrite data held in your company, click; Yes. As this backup only contains a single report, no data is overwritten.
Click; OK then log into Sage Accounts.
Calculate the manual figures for your VAT Return and RTD
Click Suppliers then click Clear to make sure no records are selected.
Click Reports then click My supplier reports and select the Postponed accounting transaction totals by tax code report.
Click Preview and select the following criteria:
Supplier Ref
Leave this as it is.
Transaction Date
Enter the dates of the VAT period you are reporting for.
Tax code (To to T99)
Enter the Tax code you want to report for. For example T39.
Click OK.
From the report take the Invoice NET balance – Credit NET balance value and manually add it to the following boxes for the relevant tax code on you RTD before submitting:
Tax code
Description
Boxes
T39
Standard rate ROW import (Resale) Postponed VAT
P2 / Z2 / PA2
R1 / Z3 / PA3
T40
Standard rate ROW import (Non resale) Postponed VAT
From the report take the Invoice VAT balance – Credit VAT balance value and manually add it to the following box on you VAT Return before submitting:
7. PA1
Sell goods to the UK
For businesses selling goods to the UK, excluding those using the Northern Ireland protocol, you should now treat this as a sale to a non-EC country.
For this you would normally use the zero rated export of goods to customers outside EC tax code, T14.
Trading goods with Northern Ireland – Northern Ireland protocol
When trading goods with Northern Ireland, to avoid a hard border, the Northern Ireland protocol has been introduced.
Buy goods from Northern Ireland
Under the Northern Ireland protocol, buying goods located in Northern Ireland should continue to be treated like intra-community acquisitions after 1 January 2021.
Sell goods to Northern Ireland
Under the Northern Ireland protocol, selling goods to Northern Ireland should continue to be treated like intra-community dispatches and distance sales after 1 January 2021.
Buy and sell services
There is no change in the way you buy and sell services to and from the UK. However, you must change your vat codes to outside the EU
e.g. If you are selling a service currently they should be using T22 Sales of services to VAT registered customers in EC which should now be T14 Zero rated export of goods to customers outside EC. This would be the same for T23 Zero rated export of goods to customers outside EC.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
3rd Party Cookies
This website uses Google Analytics to collect anonymous information such as the number of visitors to the site, and the most popular pages.
Keeping this cookie enabled helps us to improve our website.
Please enable Strictly Necessary Cookies first so that we can save your preferences!