Tips

Payroll

Reminders

Recurring events and reminders do not appear automatically in the diary each recurring date.  They only appear when the computer date is the same as the recurring event.  In addition, reminders for subsequent recurrences will not appear until the previous instances of the event have been marked as complete.

Edit an existing event or task reminder

  1. From the navigation bar click Calendar.
  2. From the Calendar or Details view, select the event or task that you want to edit then click Edit Reminder.
  3. Enter or edit what information you need to change.
  4. Reminder Description – up to 70 characters.
  5. Date to use – this can be changed.
  6. Due Date – if required edit the date of the event or when task is due to be completed.
  7. Recurrence – You can change the frequency.
  8. Reminder Pop-up Date – if required, enter or amend the date when you want the reminder to appear.
  9. Competed Date – If applicated, mark the event or task as complete, enter a date in this box.
  10. Select which users the reminder should be displayed to – you can change which users see the reminder.
  11. Notes – if required you can add additional notes.
  12. To save you changes to the event or task and return to the calendar click OK.

Deleting an existing exist or task reminder

  1. From the navigation bar click Calendar.
  2. To delete an existing event or task, from the calendar, select the required item then from the Tasks pane, then click Delete Reminder. You cannot delete multiple items simultaneously.
  3. To delete the selected event or task and return to the calendar click Yes.

If you need help amending/deleting reminders or need any other help or advice with your payroll please contact us

Accounts

Recurring entries

Recurring entries are a great way to save time.  Simply create multiple payments, receipts, Customer or Supplier Payments on Accounts or journals that happen on a regular basis such as direct debits and standing orders.  They can be processed all together each month and you can even set up reminders.

Create a new recurring entry

  1. Click Bank accounts, click Recurring items then click Add.
  2. In the Transaction type drop-down, choose the type of transaction you want, you can create the following transaction types
  • Bank, Cash, Credit Card Payment – BP, CP, VP.
  • Bank, Cash, Credit Card Receipt – BR, CR, VR.
  • Bank, Cash, Credit Card Transfer – JD, JC.
  • Customer Payment on Account – SA.
  • Journal Debit – JD – This must be posted with a balancing JC.
  • Journal Credit – JC – This must be posted with a balancing JD.
  • Supplier Payment on Account – PA.
  1. Enter the transaction details as required into each section. For help with each section you can click F1.
  2. To save the entry. Click OK.

Tip: there is a new Calculate net box at the bottom of the screen now which shows when you are setting up payments or receipts, so if you only have the Gross amount you can enter the amount, in the Net box, click Calculate net and the net will be calculated.

Tip: to set a reminder that Recurring items are due, click Settings, then Company Preferences then Parameters.  Ensure the No Recurring entries at startup check box is clear.  Now when you log into the program if any recurring entries are due a reminder will appear.

Process recurring entries

  1. Click Bank accounts click Recurring items then click Process.
  2. If required you, you can change the Show Due Entries Up To date and amend any transaction dates values and tax codes as required.
  3. Click Post.

Once posted any transaction can be amended, deleted as normal.

Suspending/editing recurring entries

You can amend any item of information except the transaction type, start date, and posting frequency once a recurring entry has started to be processed.

To edit/ suspend a recurring entry

  1. Click Bank accounts then click Recurring items.
  2. Click the recurring entry you want to edit/suspend, then click Edit.
  3. You can edit any piece of information you need to, to suspend a recurring item, select the Suspend Posting? check box.
  4. Click OK then click Close.

If you would like help with setting up, processing, editing or suspending recurring entries or need any other help with your Sage Accounts please contact us

Sage 50 Accounts V29.0 has been released, with many new and improved features such as:

  • Quick Search – this has been extended into individual fields. This makes it easier to find existing records when entering data, for example you can find a customer record using a contact name.  Quick search has been added to the Project and Departments modules.
  • Product record – Product description had doubled to 120 characters.
  • Record analysis fields – have increased from 3 to 6.
  • Email fields – you can now associate up to 6 emails addresses with a customer or supplier record.
  • Batch entry – New “Gross” column added to batch entry window to show total net + VAT Value. This is a row by row read only value.
  • Recurring items – A “Calc net” button had been added to recurring items to aid quick net calculations.

 

If you would any more information on the new Sage 50 Accounts v29.0 and how it can help your business or need help installing it or if you would like to purchase an upgrade or need any other help or anything else please contact us

Payroll

Reminders

 You can set up an event or reminder to occur once, on a specific date and time or repeatedly, every day, week, month, year, reminders can also be tailored to specific users or all users.

If you have set up a reminder, it will appear at the specific date and time, or the first time you open the software after the specified date and time.  If you have more than one reminder due at the same time, they appear in the same window.

Create a new event or task reminder

  1. From the navigation bar click Calendar, then click New Reminder.
  2. Complete the New Reminder window.
  3. Reminder Description* – up to a maximum of 70 characters.
  4. Date to Use – To use the computer date as the date of the event or task, select PC Date. To use the process date as the date of the event or task, select Process Date.
  5. Due Date* – Enter the date of the event, or when the task is due to be completed.
  6. Recurrence – If required, choose the frequency that you want the event or task to recur. Choose from daily, weekly, monthly or yearly.

Recurring events and reminders do not appear automatically in the diary for each recurring date. They only appear when the computer date is the same as the recurring event.  In addition, reminders for subsequent recurrences will not appear until the previous instances of the event have been marked as complete.

  1. Reminder Pop-up Date – To be reminded about the event or task, enter the date and time when you want this to appear. If required, from the Recurrence drop-down list, choose a time.
  2. Completed Date – If applicable, to mark the event or task as complete, enter a date in this date.

When the reminder appears, if you click Completed, a date is automatically entered here.

  1. Select which users the reminder should be displayed to – Select the Sage 50 Payroll users you want to receive the reminder. To make the reminder available to all of your Sage 50 Payroll users click Select All.  To remove all previous selected users click Clear All.
  2. Notes – If required, enter any additional information related to the event or task.
  3. To save the event or task reminder, click OK.

If you need help setting up reminders or need any other help or advice with your payroll please contact us

We can also provide a remote access service where we can directly link into your computer to help you resolve your Sage Accounts or Payroll problems.

Accounts

Setting up a New Supplier Record

A Supplier record helps you to manage contacts, track purchases and creditors.

There are two ways to create a supplier record.  You can create one within Sage 50 accounts, or you can import supplier records via an Excel spreadsheet or CSV file, which is useful if you need to create multiple records with similar information or are transferring information from another system.

How to create a Supplier within Sage 50 Accounts

Each supplier has a separate record which is unique to them.  The record holds lots of information such as contact details, details of purchase etc, bank information etc.

To create a new Supplier record, click Suppliers > New or double click any supplier and then click Clear Form.

Details

The first tab you will need to fill in is the Details tab and this is the most important tab.

ACCOUNT DETAILS

A/C* – The account reference for the supplier’s record, this is an alpha numeric field up to 8 characters . Once the record has been saved, this can’t be changed .

Company name  – The supplier’s name.

Balance – This shows the balance on the supplier’s balance.  You can add an opening balance here but we do not recommend doing that.

Inactive – Select this check box to flag the supplier’s account as inactive.

REGISTERED ADDRESS

Address, Post Code, Country – The supplier’s address details.  You can now paste in the address by clicking the icon next to the address.

VAT Number – If needed, enter the supplier’s VAT number.

EORI – If the supplier has an Economic Operator Registration and Identification (EORI) number it can be entered here.

CONTACT INFORMATION

Contact name – The name of the supplier’s main contact.

Trade contact – The name of the supplier’s trade contact.

Telephone & Telephone 2  – The supplier’s telephone numbers can be added here .

Fax – The supplier’s fax number.

Website – The supplier’s website address.

SOCIAL MEDIA

Twitter, LinkedIn, Facebook – you can add the supplier’s Twitter handle, LinkedIn and Facebook account details.

EMAIL SETTINGS & ADDRESSES

Email 1, Email 2, Email 3,– The supplier’s email addresses.

I send letters, statements, etc to this supplier via email – Select this check box if you communicate with this supplier by email.

The second tab on the supplier record is the Defaults tab

CUSTOM FIELDS

Analysis 1, Analysis 2, Analysis 3 – Use these custom fields to identify supplier types for reporting and analysis.

DISCOUNTS

Discount % – Enter the percentage discount offered by this supplier.  This is an unconditional discount.

MISCELLANEOUS DEFAULTS

Default Nominal Code – The nominal code to use by default for any batch invoices or credits for this supplier.

Use Default Nominal Code for Purchases – Select this check box to use the supplier’s default nominal code for Purchases.

Default Tax Code – The tax code to use by default for any batch invoices or credits for this supplier

Use Default Tax Code for Purchases – Select this check box to use the supplier’s default tax code for all batch invoice and credit notes.

Currency – Foreign Trader only – choose the correct currency for this supplier.

Department – Select the default department for this supplier, if required.

Reporting Password – for use with secure PDF documents.

Incoterms – Select as required.

TIP: You can copy an existing supplier’s record, highlight the relevant supplier, then click Duplicate.

Select the Credit Control Tab – it is up to you if you fill in this information

Terms

Credit Limit – The supplier’s credit limit.

Settlement Due – If your supplier offers an early settlement discount, enter the number of days the discount applies.

Sett. Discount – The early settlement discount percentage.

Payment Due – The number if days after which an invoice is classed as overdue.  In Sage 50cloud accounts V28.0 and below, this is left as zero, the default value is 30 days.  In Sage 50cloud accounts V28.1 and above, if this is left as zero, you can choose whether 0 days or 30 days is used.

Payment Due From –  Choose the required payment terms from your supplier.

Trading Terms Text – The agreed trading terms with your supplier.

Credit Reference  – The supplier’s credit reference, if required.  You can use this information to check the supplier’s credit status.

Bureau – The supplier’s credit bureau, if required.

Priority Supplier – select this check box to treat this supplier as a priority when managing payments.

Credit Position – The supplier’s credit status.

Account Status – The supplier’s account status.  You may use this feature to put the account on hold etc.

DUNS Number  – The DUNS number (Data Universal Numbering System).

Credit Review

A/C Opened – The date you started trading with this supplier.

Last Credit Review – The date you last reviewed your supplier credit details.

Next Credit Review – The date of the next proposed credit review.

Application Date – The date you applied for credit.

Date Received – The date you received credit.

Memo – Enter any relevant notes here.

Restrictions

Can charge credit – Select this check box if your supplier charges you interest for late payments.

Restrict mailing – Select this box to exclude this supplier from mailings.

Terms agreed – Select this box if you’ve agreed credit terms with this supplier.  If you don’t tick this check box when you create the supplier record, a message appears every time you access the account that states the terms have not been agreed with this account.

Account on Hold – The Account On Hold box is populated depending on the Account Status selected and is therefore not available to select.

Select the Bank Tab – it is up to you if you fill in this information

Bank Details

This is mainly used for reporting purposes.

Payment Details

This is mainly used for reporting purposes

Select the Alerts Tab – In Sage 50 Accounts v27 and above you can set up custom alerts, we have covered how to do this January Newsletter.

Select the Communications Tab – You can enter details of communications with your supplier.

Select the Memo Tab – You can enter miscellaneous information and attach documents and references to the record.

Select the Activity Tab

This screen is filled in when you start posting transactions to the suppliers account and shows the details of each transaction.

Select the Purchases Tab

This screen shows an overview of the trading between you and your supplier.

Select the Order Tab

The Orders tab shows you a summary of your supplier’s orders and their status, if you are using Sales Order Processing.  From here you can open any order to view the order details (Professional only).

Select the Graph Tab

This provides a graphical representation of the monthly invoices, credits and balances.

If you would like help with setting up supplier records or need any other help with your Sage Accounts please contact us

Not all accountants are grey.

Call us now for your FREE consultation on 01691 654545 or click here...