Setting up linked accounts in Sage 50

Summary

Update linked accounts through the wizard, settings, records, or optional feature settings in Sage 50 Accounting.

Resolution

Prerequisites

  1. Log in as sysadmin.
  2. Switch the company to single-user mode.

Use the Linked Accounts Setup Wizard

  1. Select Setup, Wizards, Linked Accounts.
  2. Select Next.
  3. Review each module.
  4. Add, remove, or change linked accounts as needed.

Set up linked accounts manually

General accounts

Retained Earnings
  1. Select Setup, Settings, General (Accounts), Linked Accounts.
  2. Update the Retained Earnings account.

Payables

Accounts Payable, Freight, Early Payment Discount, and Prepayment
  1. Select Setup, Settings, Payables, Linked Accounts.
  2. Update the required linked accounts.

Receivables

Accounts Receivable, Revenue, Freight, Early Payment Discount, and Deposit
  1. Select Setup, Settings, Receivables, Linked Accounts.
  2. Update the required linked accounts.

Payroll

Employee Payroll accounts
  1. Select Setup, Settings, Payroll, Linked Accounts.
  2. Review and update:
    • Incomes
    • Deductions
    • Taxes
    • User-Defined Expenses
Payroll expense accounts
Sage 50 Pro
  1. Open the employee record.
  2. Select the optional account setting for Record wage expenses in.
  3. Assign the desired account.

The employee record settings window.

Sage 50 Premium and Quantum
  1. Select Setup, Settings, Payroll, Linked Accounts, Expense Groups.
  2. Select the ellipsis (...) button.
  3. Enable the Linked Accounts column.
  4. Assign the appropriate accounts.

The expense group settings window.

Inventory

Item Assembly Cost and Adjustment Write-off
  1. Select Setup, Settings, Inventory & Services, Linked Accounts.
  2. Update the required accounts.

Credit cards

Used and Accepted credit card accounts
  1. Select Setup, Settings, Company, Credit Cards.
  2. Review both Used and Accepted cards.
  3. Update the Acct. field as needed.

Sales taxes

Tax tracking accounts
  1. Select Setup, Settings, Company, Sales Taxes, Taxes.
  2. Update the Acct. to track field.

Delivery Orders

  1. Select Setup, Settings, Company, Customers & Sales, Linked Accounts, Delivery Orders.
  2. Update the linked account settings.

Goods Received Notes

  1. Select Setup, Settings, Company, Vendors, Linked Accounts, Goods Received Notes.
  2. Update the linked account settings.

Configure linked accounts in customer and vendor records

Customer and vendor records

  1. Open a Customer or Vendor record.
  2. Select the Options tab.
  3. Review the linked account settings:
    • Customers use a revenue-linked account.
    • Vendors use an expense-linked account.

Configure optional linked account settings

Bank Feeds matching transactions

  1. Select Setup, Settings, General (Accounts), Linked Accounts.
  2. Assign accounts for:
    • Bank Charges
    • Interest Income

Multi-Currency

  1. Set up a rounding difference account.
  2. For setup instructions, see How to add a foreign currency.
  3. Assign an expense account for Track Exchange and Rounding Differences in.

NOTE:

Exchange rates can differ between the invoice date and the payment or receipt date.

Additional information

  • Each account can serve as a linked account only once.
  • If you create multiple deductions, each deduction requires a different linked account.
  • Open a sample company to review examples of common linked account setups.

Need more help?

Chat now

 

 

 

 

 

Solution Properties

Solution ID
221924850013524
Last Modified Date
Fri May 05 17:53:17 UTC 2023
Attributes
Product Details
Integrated Product: Blueprints
Views
0