02- General Journal

Linked Accounts & Integration P2


This is a continuation of P1 which talked about Company. under the Setup – Settings menu. the link is below for your review.

Link Account & Integration P1.


Lets continue with the tutorial.  This section will look at integrating and setting up General (Accounts), Vendor & Purchases, and Customers & Sales.

General (Accounts)

Under General (Accounts) there is Budget, Numbering, Departments, Names and Linked Accounts.

general accounts

lets look at Budget

you can set up a budget for each of the accounts. A detailed and realistic budget is one of the most important tools to guiding your business and providing the information necessary to operate within your means.

general budgetNext: Numbering

In Sage you can have a 5 digit account numbers and here you can specify the range.

general numbering

Next: Departments

Some companies need to separate departments and capture each departments expenses and income separately.

general departmentsNext: Names

You can put anything you need to track in Names.  this field can be used to sign off on documents.

general names

Next: Linked Accounts

This section is the integration section of Sage. Enter the account number for Current Earnings so that the system with know the account to used for Net Income or Loss calculations.

there is a Charges and Income section. If you add account number to this section it will use it for any over or underage that may occur during bank reconciliation or un-balanced transactions. I have left this blank because I want to choose the account rather a automatic entry.

general linked accounts

Next section is Vendor & Purchases with 5 sub sections t0 cover.

Address, Options, Duty, Names and Linked Accounts.

vendorpurchasesclick on addresses

This is very handy and limits typing. enter a default address for new vendors.

Next: Options

Aging and Early payment terms.

Next: Duty

If your company imports or exports product the account that captures Duty can go here.

Next: Names

this Section is for Additional info titles and terminology.

if you like the Name Invoice to read Bills or Vendors to be called Suppliers, it can be changed here.

Next: Linked Accounts

This is 2 part integration section. The account numbers given here will be used to record transactions accordingly. the 2 parts are:

1- Invoice and Payments

2 – Goods Received Notes

Now, depending on what version of Sage Simply Accounting you have,

The Goods Received Notes may not be an option.

Lets first look at Invoice and Payments.

enter the bank account information and currency.

enter all the account numbers you created in the chart of account for these section. depending on your company some of these sections will be left blank.

not all companies give early payment discount or prepayment on orders. so fill out what is required for your business.


Next: Goods Received Notes

If your company is in a habit of producing Goods Received Notes and you like Sage to keep track of them, enter the account number here. Keep in mind to review these accounts often and purge out any notes not needed.


Moving on to Customers & Sales

this section has 7 sub sections to cover.

Address, Options, Discount, Invoice Payments, Comments, Names and Linked Accounts.


Next: Address

Enter the default address information for new customers.

Next: Options

Frist part of Options is Aging – normally customer invoices aging is 30 to 60 to 90 days.

Second part is Customer Statements – to set up interest charged on past due invoices as well as report options.

final section is tax code – this is a default tax code for new customers and if you need to track sales reps for commission purposes.


Next: Discount

Early payment discount – enter percentage discount paid within a certain date.

and this discount can fall on a line item for sales transactions.

Next: Invoice Payment

this is an online payment method. A 3rd party company register with a fee attached,.

you can contact Sage and install the 3rd party software compatible with Sage.

Next: Comments

The comment section is to make your invoices friendly. ex: A note thanking customers for their business. as well as for Contracts, Estimates and Delivery Orders.

Next: Names

Additional info Titles and Terminology. ex: change Customers to Clients or Sales to Service.

Next: Linked Accounts

This section has 2 sub sections:

1- Invoices & Receipts

2 – Delivery Orders

From the top enter the bank accounts for customer deposits and the second section is the linked accounts for Sage to track Accounts Receivable, Default Revenue, Freight Revenue, Early Payment Sales Discount, Deposits and Prepaid Contracts, Online Payments Receivable and Online Payments Fees.

Notes: Keep in mind you may not utilize all these sections depending on your business type. There might be unused sections so leave them blank.

Next: Delivery Orders

delivery orders are processed Sage can keep track and this is where the account numbers will be defined. Reconcile these accounts on regular basis to purge what is not needed.

This concludes P2 of this tutorial.

In part 3 will look at payroll and the link is blow for your review.




































































Be the first to comment - What do you think?

Link Account & Integration P1.

For this tutorial Sage Simply Accounting 2019 Accountant Edition is being used.

If you are a beginner to Sage 50, you might want to allow it to create the chart of account for you and link the accounts for integration purposes automatically. It will work ok except each company is different and needs its own unique and customized chart of accounts.

for how to build a chart of accounts from scratch and  gear it to your company’s needs follow the link below. Otherwise this tutorial is what to do after the chart of accounts has been built.

Accounting Chart

lets get started. drop down the setup menu from the home page and choose settings. this is what you should see.

settings company informationwe are going to integrate these settings into the chart of accounts that you built.

The sections going to be covered are:

Company, General (Account), Vendor & Purchases, Customers & Sales, Payroll, Inventory & Services and last is Departments.

keep in mind that what we do here is not written in stone and can be changed at any given time.

you are already on Company – Information. this section is pretty self explanatory except maybe the fiscal start and end dates.

If you are a Sole Proprietorship or a partnership your start date is when ever you began having transactions and your fiscal year is always December 31. EX: if your first business transaction is April 12, this is considered as the fiscal start date and the fiscal year end is December 31. Your first year will be a short year but the following year will have 12 consecutive months.

If you are a shareholder of a Limited, Crop, or Non-profit, you can choose your fiscal year end.  The fiscal start date is the incorporation date, The date your company is registered with the province and the fiscal end date can not exceed more than 365 days. Ex: is your incorporation date is April 12, than your fiscal end date should be March 31. you can choose a calendar year end, Ex: Dec 31. in this way you will have a short year (April 12 – Dec 31) and the following year will be 12 consecutive months.

Next: click on System.

Settings company system


From the top, Cash Basic Accounting. CRA does not look positively on Cash Accounting. This means that if your fiscal year end is December 31 the accounts payable is zero (you don’t owe any money to suppliers) and accounts receivable is zero (your customers don’t owe you any money).

But in reality, and normal course of business you will have accounts payable and receivable balances.

let’s say on December 15 you send out a sales invoice. your customer has 30 days to pay. so, on December 31 this amount is owed to you. and same with your suppliers or utility bills. you might receive the bill in December, but you will pay it in January so at the end of December it will be owed and outstanding to be paid.

CRA wants all sales and expenses to be recorded regardless of whether or not they have been paid.

The rest of this section is your preference if you like to use cheque number or enter transaction in the future. keep in mind you can always change and update these settings.

Next: click on backup

company backupThis is the backup options. How often and how to remind you to backup. Its very important to have a regular backup.  Get into the habit of backing up. only takes a few minutes and can save your hard work.

Next: Office 365 Integration

company office 365This is a cloud option. It’s the office you know, hosted on the cloud, plus tools to enhance how teams work together and manage your company across devices. this is up to you if you need this option.


Next: Features

company featuresAll the different modules are listed here. you can check off the ones you need. For example if you do not have payroll yet, you can disable the payroll module. the check marks indicated the ones you need for your business.

Next: Payment Processing

company payment processinghere you have the option of choosing Direct Payment (cheques) or EFT Direct (Electronic funds Transfer)

there are standalone companies who work well with Sage and you can register with them to pay your supplier or employees via EFT.

Next: Bank Transactions

This is to connect your bank account through Sage Bank Feed where you can automatically download bank transactions and post entries off of the downloaded transactions. I do not use this option but if you like to use it please let me know how it goes.


Next: Credit Cards (Used, Accepted and Processing Service)

Credit Cards Used is the company or your personal credit card setup for ease of recording transactions.

company credit card usedThis section is for credit cards accepted. you can also use this section of customers pay via EFT.

company credit cards acceptedThis final section of Credit Cards is for Processing Services. This is a stand alone payment processing service that works with Sage and you can register with them.

company credit card services

Next: Sales Tax

This section has been covered and I will give the link below for your convenience.

GST Tax Table Setup

Next: Company Currency

If your company deals in US funds this is where to indicate it.

company currencyNext: Forms

Here is a list of all the forms and the numbers that they start with.


company forms

Next: email

this section is nice because you can choose a small write up that would automatically show up when your sending an email through Sage. click on each section and write up an appropriate dialog pertaining to that section.

company emailNext: Date Format

I like to use the long date format where it shows the month as June instead of a number (06)

it is easier to find documents with the long date format. But this is totally up to you.

company date formatNext: Sage Accounting Connection         

this is the cloud connection of Sage.  If your bookkeeper is in another town this system might work for reviewing transactions and financials.

company sage accounting cloudNext: Shippers

This is great for your shipping department. here you can add the most popular shipping companies that you use and include them on the sales invoice. no guessing game how the product will be

company shippersNext: Logo

Company logo can be set in this section and it will reflect on your invoice

company logoNext: Names

This is Additional information title. choose your language to appear.

company names

This tutorial concludes the Company section the next part is General (Accounts) section and the link is below.

Linked Accounts & Integration P2

Link Accounts & Integration P3

Thanks for viewing and if there are specific question please drop me a note.













































Be the first to comment - What do you think?

Next Page »