helpwith.salesorder.com
  • Read me first
  • Start!
    • How to move forward
  • Video Index
  • Live in 5
    • Step 4: Solution Plan
      • Workflow Guides
    • Must read: Data Migration
      • Read First: ASIC and presets
      • Transaction Migration Primer
      • Migrate transactions
      • Migrate from Quickbooks
        • How to categorize Quickbooks 'Open' Purchase Orders
    • Step 5: Launch Sequence
      • T -6: System Settings
      • T -5: Baseline preparation
      • T -4: 'Open' transactions
      • T -3: Trial balance
      • T -2: Set Stock levels
      • T -1: User testing / Dry run
  • Customer references?
  • Common Actions
  • Company
    • Workers and Users
      • Add new User login
      • Owners
  • Organizer
    • Memo
    • Contacts
    • Calendar
    • Email
    • Attachments and Linking
  • Expenses/Timesheets
    • Expense Claims
      • Mileage Claims
    • Timesheets
  • Sales Forecasting
  • Sales
    • Leads
    • Prospects
    • Customers
      • Credit Controls
    • Jobs
    • Sales Quote
    • Sales Orders
      • Common Sales Tasks
        • Pre-Authorization/Pre-Payment with BASYS
      • Ordered Item History
      • Stock Allocation
      • Pick-Pack-Ship Process
      • Sales Order List
      • Drop Ship
      • Special Orders (Just in Time)
      • Discounts
      • Prepayment/Deposit
    • Cash Sales
    • Sales Invoices
    • Payments from Customers
      • Processing digital Payments
      • Apply Credit Automatically on Payments
    • Customer Credit Notes
    • Customer Refunds
    • Delivery Notes (a.k.a Packing List)
    • Customer Statements
    • Shipments
      • Pick List
    • RMA
    • Commission automation?
  • Purchasing
    • Suppliers
    • Purchase Quotes
    • Purchase Orders
    • Cash Purchases
    • Item Receipts
    • Bills (Purchase Invoices)
    • Payments to Suppliers
    • Supplier Credit Notes
    • Supplier Refunds
    • PO Generator by Item
    • PO Generator by Order
  • Inventory Forecasting
    • Inventoro
  • Products/Services
    • Items - which ones?
      • Preferred Suppliers
      • Stock Items (SKUs)
      • Stock Assemblies
      • Kits
      • Non Stock Items
      • Group Item
      • 'Calculation' Items
      • Service Item
      • Matrix Item
    • Sites
    • Stock Adjustment
    • Stock Manager
    • Stock Locations
    • Categories, Tags and Attributes
      • Categories
      • Tags
      • Attributes
    • Images on Items
    • Item Extra Info
    • Price Levels
    • Price Lists
    • Advanced Price Lists
  • Banking
    • Cashflow Forecast
    • Checks
    • Bank Reconciliation
    • Petty Cash Accounts
    • Credit Cards
    • Money In and Out
  • Accounting
    • Accounting Periods
    • Payment Terms
    • Tax
      • Sales Tax
        • US Tax Codes
      • Tax Authorities
        • Working with HMRC (UK Specific)
      • Tax Codes
      • Tax Groups
      • Item Tax Options
      • VAT Returns
    • Currencies
    • General Journals
    • Memorized Transactions
    • Reverse Transactions
  • WMS: Warehouse Management
    • Stock View
    • Goods In
    • Goods Out
    • RMA
    • Shipping
    • Pallets
    • Kits and Assemblies
    • Stock Actions
    • Stock Count
    • Locations
    • History
    • Admin
    • Config
    • Barcode Scanner App â›­
    • Multipacks
    • Overship Tolerance
    • Expiry Date
  • WMS Setup
  • Third-party logistics (3PL)?
  • Shipping
    • FedEx Manager Integration
    • UPS WorldShip Integration
  • Reports
    • Classifications
    • Report Mailer
    • Email Reports on Schedule
    • Accounting Periods
  • Setup
    • Roles
    • Email templates
    • Payment Processors
      • Basys: low fees, VIP service
      • Authorize.net
      • Cybersource
      • PayPal
      • USAePAy
      • Paragon (PAYA)
    • Configuration
      • Company â›­
      • Memo â›­
      • Ref # â›­
      • Leads â›­
      • Prospects â›­
      • Customers â›­
      • Credit Controlsâ›­
      • Jobs â›­
      • Sales Quote â›­
      • Sales Order â›­
      • Sales Invoice â›­
      • Customer Credit Note â›­
      • Cash Sale â›­
      • Statements â›­
      • Shipment â›­
      • Customer Refund â›­
      • Delivery Notes â›­
      • RMA â›­
      • Pick List â›­
      • Supplier â›­
      • Purchase Quote â›­
      • Purchase Order â›­
      • Item Receipt â›­
      • Cash Purchase â›­
      • Bills â›­
      • Payment to Suppliers â›­
      • Supplier Credit Notes â›­
      • Supplier Refunds â›­
      • 1099 Categories â›­
      • Kit â›­
      • Accounts â›­
      • Accounting Periods â›­
      • VAT â›­
      • Email Accounts â›­
        • OAuth for Outlook 365 â›­
      • Company Security â›­
        • Two Factor Authentication
      • Classifications â›­
      • Document Templates â›­
      • Shipping Carriers
      • Sales Invoice â›­
      • Payments from Customers â›­
      • Sales Opportunities â›­
    • EasyPost â›­
    • Shipstation â›­
    • Web to Lead
    • Import data templates
    • Exporting Data
    • Your Account
  • Shopping Carts b2c
    • âš  Live Shopping Carts
    • Shopping Cart controls
    • Shopify â›­
    • BigCommerce â›­
    • Magento â›­
    • Woocommerce â›­
    • Prestashop â›­
  • Trade Acceleration Portal 2.0
    • TAP Users
      • Customers
      • Sales Reps
      • Sales Teams
      • Administrators
        • Configure barcode order entry
        • Get your Inventory List from QuickBooks
    • TAP UX
      • Global Brand Style
      • Themes
      • Pages
      • Blocks
        • Group Start
        • Plain Text
        • Image
        • Hyperlink
        • Menu Matrix
        • Title
        • Custom HTML
        • Block Configurations
          • Pixels and Percentages
          • Flex Box Settings
            • Flex Wrap
            • Justify Content
            • Align Items
            • Column/Row Gap
            • Align Content
          • Background
          • Dimensions
          • Border
          • Slider & Carousel
          • Margin Padding
          • Overflow Settings
      • Content Management System (CMS)
  • Trade Acceleration Portal 1.0
    • Configure barcode order entry
    • Get your Inventory List from QuickBooks
  • Customization
  • Volume Automation
  • EDI
    • EDI integration via XML
  • REST API
  • Schema Documents
Powered by GitBook
On this page
  • Accounting - need to know
  • Chart of Accounts
  • Add new account
  • Nominal Codes
  • Configurable GL Accounts
  • New Account Fields
  • Cost of Goods method
  • Tax support
  • Financial reporting
  • Excel Export
  • Configurable accounting on transactions
  • Discount calculations
  • Credit Controls
  • Credit Note for Unused Payment
  • Bank reconciliation
  • Check Printing
  • Configurable period closure

Was this helpful?

Accounting

Multicurrency, tax agnostic general ledger

PreviousMoney In and OutNextAccounting Periods

Last updated 10 months ago

Was this helpful?

Media

Overview

Accounting Periods

Multicurrency

Banking

Sales (Accounts Receivable)

Purchasing (Accounts Payable)

Accounting - need to know

The system has a comprehensive set of functions that can be configured to implement and manage accounting processes to a clear and accurate standard. These functions pivot on the general ledger, which is multicurrency, tax agnostic and has a full audit trail.

Key functions are:

  • Multicurrency

  • Chart of Accounts

  • Nominal Codes

  • Configurable GL Accounts

  • COGS average cost method

  • Tax tracking for output tax (e.g. Sales Tax) and input/output tax (e.g. VAT)

  • Financial Reporting

  • Configurable accounting on transactions

  • Credit control on transactions

  • Bank reconciliation

  • Check printing

  • Configurable period closure

  • Always on audit trail

The system supports up to four Decimal places.

See Setup>Configuration>Accounts>Numerical Formats

Chart of Accounts

The chart of accounts is an adaptable listing of all accounts used in the general ledger. The system uses the accounts in the chart to organize and aggregate posting transactions for reporting to GAAP standards.

Accounting>Chart of Accounts

Add new account

Accounting>Chart of Accounts>+ (new account)

Setup>Import data>Accounts

You can specify a parent child relationship for accounts.

To add a new account in the correct position in your existing Chart of Accounts structure turn on and use Nominal codes.

Assign the appropriate nominal code number to tell the system where you want the account to appear.

Nominal Codes

Accounts can be assigned a nominal code (account number),. The accounts are usually numeric, but can also be alphabetic or alphanumeric.

To display nominal codes

Setup>Configuration>Accounts>Display nominal codes

Nominal codes can be imported or manually added.

If you are inserting a new account, the Nominal code value will determine where the account is inserted in the Chart of Accounts order.

  • Setup>Import data>Accounts

  • Accounting>Chart of Accounts>+ (new account)>Nominal Code

Configurable GL Accounts

Users can set account types (income, asset, etc) and configure control and sub-account (parent-child) relationships within the chart of accounts. Each account can be assigned a:

  • Cash flow category (operating, finance, investment)

  • 1099 category

  • Classification - an arbitrary ‘class’ for building reports

  • Currency - Balance sheet accounts only

Expense accounts can be selected to display on Expense claims and defined as reimbursable. See 'Expense Claims'

New Account Fields

Account name

What you want to see in the Chart of Accounts table.

Nominal Code

The value in this filed will appear in tables and reports if the 'Use Nominal Codes' check box is enabled (see above).

If you are inserting a new account, thvalue will determine where the account is inserted in the Chart of Accounts order.

Currency

Set on Balance Sheet accounts only.

Parent Account

The dropdown will display a list of parent options.

Opening Balance

Set this whenever you are ready.

Cash Flow Category

Operating, Finance, Investment?

1099 Category

Account Class

An additional reporting control. See 'Classifications'.

Cost of Goods method

The system uses the Average Cost method. Costs are assigned to inventory Items based on the total cost of goods purchased or produced in a period divided by the total number of items purchased or produced. The average cost method is also known as the weighted-average method.

Tax support

Taxjar integration is supported. TaxJar is a tool to automate the recording, reporting and filing of Tax. See 'Taxjar'.

1099 categorization and reporting for Suppliers is supported.

Financial reporting

Run the following reports

Reports>Standard Reports>Accounting

  • Profit and Loss

  • Balance Sheet

  • Statement of Cash Flows

  • Cashflow Forecast

  • Trial Balance

  • Account Entries

  • Transaction Journal

  • General Ledger

Excel Export

All reports can be exported to Microsoft Excel.

You can leverage the rich capabilities of Microsoft Power BI to significantly enhance your Financial reporting. See 'Power BI'.

Configurable accounting on transactions

Users can configure Items (i.e. SKUs) to post to specific general ledger accounts when transactions (i.e. Sales Invoices) are posted.

Default accounts can be specified for:

  • Tax Liability

  • Inventory Asset

  • Cost of Goods Sold

  • Income

  • Expense

  • Sales Discount

  • Markups

  • Bank Charges

  • Bank Interest

  • Stock Adjustment

  • Pending Item receipts

  • Currency Gains and Losses

  • Customer Payment discounts

  • Supplier Payment discounts

Goto: Setup>Configuration>Accounts (Default Accounts)

Discount calculations

There's a method that discounts the line item by the discount percentage entered into the Discount column in the respective row.

The discount is not posted to the General Ledger.

How the discount is applied is configurable:

Setup>Configuration>Accounting>Accounts>Discounts>Discount Calculation.

Choose and preset:

  • Using Unit Price/Cost

  • Using Total Pre-tax amount

Depending on the option selected in the Accounts configuration page, the discount is either applied to the Unit Price (i.e before the line total is calculated) or on the pre-tax amount (after the line total is calculated).

Credit Controls

The system has four functions to support credit policies:

Payment terms: Users can set payment term parameters, specifically:

  • Term name

  • Due in a specified period

Goto: Accounting>Payment Terms>+ (new payment term)

Credit control automation: Users can set customer credit control parameters to automate credit checks specifically:

  • Use Credit Limit (set on the Customer master, ‘Credit Limit’)

  • Use Invoices past due

Goto: Sales>Customers>Configure>Credit Control

Users can specify rules to place customers on hold, specifically:

  • Allow nothing (no new transactions)

  • Allow pending Sales Orders

  • Allow Cash Sales (sales receipts)

  • Allow pending Sales Orders and Cash Sales (sales receipts)

Goto: Sales>Customers>Configure>Credit Control

Administrators can set permissions on user ‘Roles’ to override credit controls.

Goto: Setup>Roles>Permissions>Customers

Early payment discount: Users can set parameters to specify when discounts are applied specifically:

  • Discount within n Days

  • Discount %

Goto: Accounting>Payment Terms>+(new payment term)>Early payment discount

Aging debtors analysis: Users can review outstanding receivables.

Goto: Reports>Standard Reports>Customers>Sales Invoice Aging

Credit Note for Unused Payment

You can configure the Accounting to automatically create a Credit Note for unused Payment, The default behavior is just to display the balance on reports.

Setup>Configuration>Accounts>General>Create credit note for unused payment

Bank reconciliation

Users can select a Bank Account and perform reconciliations aligned with statement dates for financial periods.

Goto: Banking>’Bank Account’>Actions>Reconcile

Check Printing

Configurable period closure

Periods can be closed in these configurations:

  1. Disallow editing or new transactions prior to the close date

  2. Allow journals to be posted prior to the close date and up to a specified date in the future

Goto: Setup>Configuration>Accounts>Actions>Close Accounts

Users can set a ‘Close date’ so as the system records the date upon which the accounts were last closed.

Account Closure
Notes

Closed by

User

Date

The date this close was committed

Close Date

Closed up to

Open Until

Open up to

Allow Journals

Comments

Note to self :-)

Close the Accounts

Action to commit this transaction

To review the Accounts closure history, go to:

Setup>Configuration>Accounts>Find>Accounts Closure History

Box number & Type e.g. Box 1 - Rent etc. See ''.

Tax functions are explained in '' and 'Value Added Tax'.

See .

Sales Tax
Checks
Accounting Overview
Chart of Accounts
Set up Nominal Codes
Set up parent (control) accounts
General Journals
Enter Journals
Reverse Journals
Memorize Journals
Accounting 101
Accounting Periods Overview
Accounting and Configuration
Accounting Periods: Lists and Documents
Accounting Periods on Documents
Accounting Periods and Reporting
Add a Currency
Currencies on Reports
Currencies on Trading Partners and Documents
Fix Foreign Prices and Costs on Items
Currency Adjustments
Fix Foreign Prices
Bank Accounts
Petty Cash Accounts
Credit Card Accounts
One-off Payments and Enter Purchases
Checks
Bank Reconciliation
Memorized Transactions
Create a Bank Account
Enter Purchases and one-off payments
Memorize Transactions
Create Bank Account
Credit Control
Sales Invoice
Customer Payments
Cash Sale
Customer Statements
Customer Credit Notes
Customer Refunds
Payment Terms
Customer Prepayments
Create Customer Payment from Sales Invoice
Purchase Invoices (Bills)
Item Receipts
Supplier Payments
Supplier Credit (Debit) Notes
Supplier Cash Purchase
Supplier Refunds
1099 Misc Tracking
Supplier Deposits and Prepayments
1099