Sage Hints and Tips

Sage hints & tips – Week 53

Friday, March 16th, 2012
Mark Jones, Director, Broomfield & Alexander

Mark Jones, Director, Broomfield & Alexander

Because 2012 is a leap year, week 53 includes two days this year – Wednesday 4 and Thursday 5 April.

You’ll only have a week 53 if you’re due to process any weekly, two-weekly or four-weekly paid employees on either of these days.

Will I have a week 53?

In the 2011/2012 tax year, you will have a week 53 if the following applies:

Normal pay day is a Wednesday or Thursday and…

  • Weekly paid employees are last processed on Wednesday 28 or Thursday 29 March 2012.
  • Fortnightly paid employees are last processed on Wednesday 21 or Thursday 22 March 2012.
  • Four weekly paid employees are last processed on Wednesday 7 or Thursday 8 March 2012.

In each of these instances, the employees are due to be processed next on 4 or 5 April 2012, week 53.

Note: If your normal processing date falls on Wednesday 4 or Thursday 5 April 2012, but you intend to process your payroll earlier, you must still set the date to the correct date.

These are the only scenarios where a week 53 should be processed, as the next processing date for all other pay dates falls into the 2012/13 tax year. Monthly employees do not have a week 53.

Tip: There is nothing different that you need to do to process week 53. Simply set your processing date to the correct date and follow your normal processing routine.

You must ensure that the payroll for week 53 is updated, just like any other pay period, before beginning the year end process.

Note: If you don’t have a week 53, once you’ve processed and updated your final pay period, you can start your year end routine.

How tax and national insurance (NI) is calculated in week 53

Tax

To comply with government legislation, Sage 50 Payroll correctly calculates tax in week 53 using a week 1 / month 1 free pay allowance. Any previous pay and tax is ignored. This means that tax is calculated on the gross pay for tax this period only, using a weekly pay adjustment at the current tax code. If the employee is paid fortnightly or four weekly, the two or four weekly pay adjustment is applied.

Note: If the employee’s total pay for the year, including the pay for week 53, is less than their free pay allowance, then no tax is deducted in week 53. For example, a weekly employee on tax code 747L has an annual free pay allowance of £7479.12. They have been paid £5000 up to and including week 52, then is paid £500 in week 53. As £5500 is less than their free pay allowance, no tax is deducted.

NI

For employees, NI is calculated as in any other pay period, using the weekly, two weekly or four weekly thresholds, as appropriate.

For directors using the table method, their NI is recalculated in week 52 using the annual thresholds. The NI for week 53 is then calculated cumulatively on a year to date basis. For directors using the year to date method, their NI for week 53 is calculated cumulatively as in any other pay period.

How does week 53 appear on reports?

P11 Deduction Cards (PAYE and NIC)

Payments processed on 5 April appear as a separate line on the P11 with 53 in the Wk/Mth No column.

Note: Total pay to date (column 3), Total free pay to date (column 4) and Total tax due to date (column 6) show the amounts for week 53 only, not cumulative values.

P14/60

Forms P14/60 have a Week 53 payment indicator box. This box is only populated if a payment has been updated on 4 or 5 April. This indicates that an extra tax calculation has been performed in this tax year and shows one of the following values:

  • Weekly paid employees – 53
  • Fortnightly paid employees – 54
  • Four weekly paid employees – 56

Note: This payment is referred to as week 53, however fortnightly or four weekly paid employees have tax deducted using the two or four weekly pay adjustment. The week 53 payment indicator box reflects this by showing week 54 or 56 for these payment frequencies.

The tax period shows week 53, but I don’t have a week 53

One of the first steps of the year end process is to change the process date to 5 April. This is the date that should be used for all year end reports as it is the last day of the current tax year.

After changing the date the tax period displayed on the status bar shows tax week 53. This does not mean that you have to update week 53. You only need to process week 53 if your employees are weekly, fortnightly or four weekly paid and your normal processing date is 4 or 5 April 2012.

Why not follow @BroomfieldWales on Twitter to keep up with the latest information on Sage and other business and financial topics, or simply register for our monthly newsletter, you can also contact us directly on  Sagesolutions@broomfield.co.uk

 

 

Sage 50 offers, March 2012

Friday, March 9th, 2012

March 2012 Offers

Please contact Sagesolutions@broomfield.co.uk directly for more information on any of the below offers.

All offers detailed below are available until the 30 April 2012, unless otherwise stated.

Charity Discount

15% off Sage software, support and services (exceptions apply, see terms)

New and Existing customers who are listed on the UK Charities Register.

• Only businesses that are currently listed on the UK Charity Commission Register are eligible for this discount

• Businesses who are waiting to be registered are not eligble

• ‘Not-for-profit’ and ‘CIC’ businesses are not eligible

• Applies to standalone Instant Accounts, Instant Payroll, 50 Accounts, 50 Payroll, 50 HR, 50 Job Costing, 50 Forecasting, 50 CIS and ACT! software or support contracts (excluding renewals)

• Applies to Sage Stationery and Training.

• Does not apply to services provided by Sage Customer Services such as report design, data repair etc.

Competitor Trade In

25% off Sage software

New and Existing customers buying any item included in the promotion for the first time and currently using a competitor product – see Terms

• Applies to standalone 50 Accounts, 50 Payroll, 50 HR, 50 Job Costing, 50 Forecasting, 50 CIS and ACT! products

• Does not apply against products developed by the Sage Group of companies (inc. TAS)

• Proof of competitor software ownership required in the form of a)Screenshot that clearly displays their existing software is registered under their business name and matches that shown on InTouch b) actual, faxed or email copy of original purchase receipt for their existing software.

Instant Accounts End of Life

Instant Accounts EOL version customers can get 12 for 9 on SCVE or 25% off when they upgrade to latest version

Expires: 30th April 2012 for supported customers

Existing Instant Accounts v14 supported customers or those whose support is due to expire between now and 30th April 2012

• Can not be used with any other Instant Accounts promotion

• Customers who take up this offer within 30 days of a new release will not be entitled to the next version free of charge

• SCV discount can be used with 25% off upgrade

50 Accounts End of Life

50 Accounts EOL version customers can get 12 for 9 on SCVE or 25% off when they upgrade to latest version

Expires: 30th April 2012 for supported customers

Existing 50 Accounts 2008 supported customers whose support is due to expire between now and 30th April 2012

• Can not be used with any other 50 Accounts promotion

• Customers who take up this offer within 30 days of a new release will not be entitled to the next version free of charge

• SCV discount can be used with 25% off upgrade

50 Payroll End of Life

50 Payroll EOL version customers can get 12 for 9 on SCVE or 25% off when they upgrade to latest version

Expires:  31st March 2012 for supported customers

Existing 50 Payroll 2008 supported customers whose support is due to expire between now and 31st March 2012

• Can not be used with any other 50 Payroll promotion

• Customers who take up this offer within 30 days of a new release will not be entitled to the next version free of charge

• SCV discount can be used with 25% off upgrade

20% off Stationery for first time buyers

Any item of Standard Stationery that the customer has never bought before for will be discounted by 20%

Expires:  Until further notice

New and existing customers

Repeat purchases to be charged at full price

Only includes Standard Stationery                                                                                                                                                                  Only available on items that the customer has never bought before or has at least not bought within the last two years

Instant to Sage 50 Accounts

Up to 30% off a 50 Accounts upgrade for existing Instant Accounts customers

Expires: 31st March 2012

Existing customers only

  • This promotion applies to ‘up-the-range’ purchases of 50 Accounts only
  • Discounts available include 20% off software only upgrade
  • 25% off software upgrades with SCV
  • 30% off software upgrades with SCVE
  • This promotion can not be used with any other promotion or discount provided by Sage

25% off when buying Accounts and Payroll

25% off when buying any Sage Accounts and Sage Payroll software together

Expires: 31st March 2012

  • This promotion applies to the purchase of Instant Accounts, 50 Accounts, Instant Payroll and Sage 50 Payroll software and support only.
  • Customers must buy at least one Accounts related item (software or support) and one Payroll related item on the same call.
  • Applies to the purchase of primary license, upgrade and SCV/SCVE sales
  • Excludes the purchase of Sage bundles and Packages
  • This promotion can not be used with any other promotion or discount provided by Sage.

Why not follow @BroomfieldWales on Twitter to keep up with the latest information on Sage and other business and financial topics, or simply register for our monthly newsletter.

Important Payroll Year End News

Friday, February 17th, 2012
Mark Jones, Director, Broomfield & Alexander

Mark Jones, Director, Broomfield & Alexander

The legislation for the submission of the online P35 form has changed.

If you use Sage 50 Payroll then you will need to be on the latest version, version 18 for 2012, or have valid SageCover on versions 2008 – 2011, to ensure that you receive the Year End pack with these important legislative changes.

If you do not have the above, then the online submission will fail.

You will still be able to submit via the HMRC portal, but if you want to do this through Sage 50, you will need either the SageCover or the version upgrade, available on February 27.

Please contact us on sagesolutions@broomfield.co.uk for more information or assistance.

Why not follow @BroomfieldWales on Twitter to keep up with the latest information on Sage, Liquid Online Accounting and other business and financial topics, or simply register for our monthly newsletter.

 

Sage hints & tips – Sage 50 Accounts iPad app

Tuesday, February 14th, 2012
Mark Jones, Director, Broomfield & Alexander

Mark Jones, Director, Broomfield & Alexander

Since the release of Sage 50 Accounts Mobile last year, Sage have been working hard to extend the compatibility of the service with different platforms and devices. The great news now is that Sage 50 Accounts Mobile is now fully optimised for iPad and the application is available through the Apple app store here .

This is the next step in their commitment to continue developing the use of mobile technology to bring greater value for  customers and help drive access to business data any time, anywhere.

All existing Sage 50 Accounts Mobile users have received an update automatically, which includes iPad users being updated to the iPad optimised version.

What does it look like?

Sage 50 Accounts - iPad app

 

 

 

 

 

Why not follow @BroomfieldWales on Twitter to keep up with the latest information on Sage and other business and financial topics, or simply register for our monthly newsletter.

Sage hints & tips – Clearing Sage Payroll user locks

Thursday, December 22nd, 2011
Mark Jones, Director, Broomfield & Alexander

Mark Jones, Director, Broomfield & Alexander

Problem – You get an message saying that you “user is already logged into another computer” when you attempt to login to Sage Payroll.

Solution – you can use the following steps to clear this lock.

1. Check that all users are out of the software if using a multi user system, including yourself

2. Find and open the program called Sage Payroll DB Utilities

3. Select the company you have a user locked out of and click the Clear Locks button

4. When the process has completed successfully you will get the Locks Cleared Successfully message

If you would like any help in setting this up, then get in touch with us at sagesolutions@broomfield.co.uk and we can help you get it up and running.

Why not follow @BroomfieldWales on Twitter to keep up with the latest information on Sage and other business and financial topics, or simply register for our monthly newsletter.

Sage hints & tips – Excel integration

Wednesday, December 21st, 2011
Mark Jones, Director, Broomfield & Alexander

Mark Jones, Director, Broomfield & Alexander

The Sage Excel Integrated Reporting function is a clever little app that improves what you can do with Sage 50 Accounts.  If when you output reports to Excel, you still use the convert to csv option then this is the perfect hint & tip for you!

From version 11 onwards, Sage includes an excellent little app which integrates seamlessly with Excel.  Once installed all you need to do is go to the add-ins tab in Excel.  Choose a favourite Sage report from a drop down, and the report will then run and deposit the data straight into the spreadsheet.  Apart from this being much faster than outputting to csv, all of the data is put into proper columns with headings and there is no editing needed.

To set it up do the following:

  1. For Microsoft Excel 2007 and above, open Excel and go to Options.
  2. Go to the Add-ins section and select any of the Sage add-ins.  Click OK.
  3. For Sage Accounts v14 and above you also need to go to Add-ins, select Manage, choose COM Add-ins> Go and then select the Sage Excel Integration tick box.

Now you need to go into Excel and connect it up to your company’s data.

  1. For Microsoft Excel 2007 and above, go to the Add-ins Tab.  You should now see ‘Sage’.
  2. Choose Select Company.  A login box to Sage Accounts pops up. It’s a good idea to have already created a new user account in Sage for the exclusive use of the integration link and don’t worry; it doesn’t count as a human user so you won’t need to increase your licence.
  3. Enter the Logon name, Password, and select your Company.
  4. Browse to your Sage company data directory (you can find where this is by going to Help, about in Sage).  Select setup.dta.
  5. Select ok.  You are now all set up and the power of Sage Excel Integration is yours to command!

Finally, go to the right hand box on the ribbon that is not greyed out.  Choose a report from the drop down and after clicking on Insert the familiar Sage report criteria box will appear.  Once you hit ok then then, as if by magic, data will drop straight into Excel.

If you would like any help in setting this up, then get in touch with me at sagesolutions@broomfield.co.uk and I can help you get it up and running.

Why not follow @BroomfieldWales on Twitter to keep up with the latest information on Sage and other business and financial topics, or simply register for our monthly newsletter.

Sage hints & tips – Quick Print feature

Wednesday, August 31st, 2011
Mark Jones, Director, Broomfield & Alexander

Mark Jones, Director, Broomfield & Alexander

In Sage 50 Accounts 2012, you can use the new Quick Print feature to print invoices, quotations and orders with just one click. You don’t need to select which layout or printer to use, making the process faster and easier.

You can set the default layouts you want to use in Settings > Invoice & Order Defaults > Quick Print tab. Once you’ve done this, to print a selected invoice, quotation, sales order or purchase order, from within the relevant module click Quick Print.

If you have any problems, you can contact us on Sagesolutions@broomfield.co.uk

For more useful hints and tips, why not join us at our free Sage 50 Accounts seminars.

Why not follow @BroomfieldWales on Twitter to keep up with the latest information on Sage and other business and financial topics, or simply register for our monthly newsletter.

Sage hints & tips – Nominal link, lock date feature

Wednesday, August 24th, 2011
Mark Jones, Director, Broomfield & Alexander

Mark Jones, Director, Broomfield & Alexander

If you use the nominal link and Sage 50 Accounts 2012, there’s an important update that you should install.

Sage 50 Accounts 2012 has a Lock Date feature where you can lock down a period so that specified users are restricted from posting transactions into the locked period.

If you attempt to post the nominal link into a locked period and you log into accounts as a user who does not have access to locked periods, a message appears to say that it has been successful, however no transactions have been posted to accounts.

You can find the update you need on your Sage 50 Accounts 2012 CD.

If you have any problems, you can contact us on Sagesolutions@broomfield.co.uk

Why not follow @BroomfieldWales on Twitter to keep up with the latest information on Sage and other business and financial topics, or simply register for our monthly newsletter.

Sage hints & tips – Sage 50 Mobile app launch

Wednesday, August 17th, 2011
Mark Jones, Director, Broomfield & Alexander

Mark Jones, Director, Broomfield & Alexander

With the launch of Sage 50 Accounts 2012 comes the launch of Sage 50 Mobile.

The Sage 50 Mobile app is totally free of charge and is currently available for the iPhone and Blackberry.  It will be available for Android phones and iPads later this year.

With Sage 50 Mobile you’ll have real-time instant access to your customers, suppliers, Products and Pricing, Bank and Financials, where ever you are and whenever you need it.

The service is simple to set up and easy to use. It’s great for a variety of users who can have read and write access levels set up according to their needs but don’t necessarily need in-depth accounts knowledge.

For further information or to see a demo of the new Sage 50 Accounts 2012, please contact us on sagesolutions@broomfield.co.uk

 

Sage hints & tips – Advancing pay

Thursday, August 4th, 2011
Mark Jones, Director, Broomfield & Alexander

Mark Jones, Director, Broomfield & Alexander

It’s that time of year again when your employees are taking their summer holidays. If you need to pay their wages before they jet off, you can use the Advance Pay option in Sage 50 Payroll.

Using this option ensures that tax and national insurance is correctly calculated over the whole holiday period rather than in one lump sum.

In Sage 50 Payroll you can pay an employee in advance, for example when they take holiday and want to receive their holiday pay before the holiday period.

To ensure that they are not processed again accidentally during the holiday period, Sage 50 Payroll also flags the employee as being on holiday.

For more information about when and how to use the Advance Pay option please contact us on sagesolutions@broomfield.co.uk.

For information on the fully managed, confidential payroll service we provide, please contact us on 0844 770 9598

Why not follow @BroomfieldWales on Twitter to keep up with the latest information on Sage and other financial topics, or simply register for our monthly newsletter.