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

Was this helpful?

  1. Live in 5
  2. Step 5: Launch Sequence

T -3: Trial balance

It's time to set the Accounts receivable and payable balances in your new system.

PreviousT -4: 'Open' transactionsNextT -2: Set Stock levels

Last updated 1 year ago

Was this helpful?

You’ll need to decide on a start date (New System Date a.k.a. NS Date) for accounting for new transactions in the new system. This will be the day after your Cut-off date.

#
From Quickbooks
From another system
1

'Open' posting open transactions preparation: You'll need AR balance by Customer, and AP balance by Supplier. Collate unused AR and AP credit.

'Open' posting open transactions preparation: You'll need AR balance by Customer, and AP balance by Supplier. Collate unused AR and AP credit.

null

2

Setup Migration Control account: Create a General Journal and transfer the Trial balance.

Setup Migration Control account: Create a General Journal and transfer the Trial balance.

null

Read this balance migration process overview

Customer Balances (Accounts Receivable)

The transactions that make up the balances in your old system are safely stored and recorded. So why would you move them?

Transfer the AR balance (as per the Trial Balance) from the old system to the Migration Control Account (MCA) to set the opening balance.

Make a memo note ‘ Old system balances - this account will be cleared at a later stage’.

The overall objective is to zero the old system balance recorded in the MCA. To do this use a journal to debit the Customer account with their opening debit balance and credit the MCA.

Creating a Journal with the balance is significantly less effort and less prone to error and confusion than moving Invoices and Credit Notes.

When the journal is completed the AR balance for each Customer will be automatically reflected on the Customer master.

When the customer makes a payment for an Invoice in the old system, you use a journal to debit the bank and credit the customer's AR balance.

To make it efficient and easy to record multiple journals there is an ‘Upload Journals’ sheet in Setup>Import Data.

Supplier Balances (Accounts Payable)

It’s just the inverse of the Customer balances method.

See the Migration Control diagram below for an example.

How do I report my Customer AR balance detail in Quickbooks?

You need to report 'Open' Invoices and Credit Memos.

Go to Quickbooks>Reports>Customers & Receivables>Customer Balance Detail

Make sure you set 'Dates' to 'All'.

Click 'Customize' and enable the following columns:

‘Paid’, ‘Open Balance’.

Disable ‘Class’ and ‘Balance’.

The report will list all of the ‘Open’ AR transactions by Customer with their individual ‘Paid’ status and Open Balance.

Notice unapplied Credit memos appear as ‘Unpaid’ and with a negatively signed balance.

You need to add the ‘Open’ balances of AR transactions to a General Journal.

How do I report my Supplier AP balance sheet detail in Quickbooks?

You need to report 'Open' Item Receipts, Bills, and Debit Memos.

Go to Quickbooks>Reports>Vendors & Payables>Customer Balance Detail

Make sure you set 'Dates' to 'All'.

Click 'Customize' and enable the following columns:

‘Paid’, ‘Open Balance’.

Disable ‘Class’ and ‘Balance’.

The report will list all of the ‘Open’ AP transactions by Customer with their individual ‘Paid’ status and Open Balance.

Notice unapplied Debit memos appear as ‘Unpaid’ and with a negatively signed balance.

You need to add the ‘Open’ balances of AP transactions to a General Journal.

How and where do I set up the Migration Control Account?

You’ll need to set up a Migration Control Account as a Current Liability account in the general ledger of your new system.

A successful accounting data migration relies upon detail. So you should separate and organize your migration control accounts like below. If you're using nominal codes we suggest the following:

  • 99990 Migration Accounts Payable

  • 99991 Migration Pending Item Receipts

  • 99992 Migration Accounts Receivable

  • 9999X Migration XX etc.

Accounts Payable, Pending Item Receipts GL Accounts? - remember, the balances for Item Receipts go into the Pending Item Receipts account. Quickbooks puts both the Bills and Debit notes, AND the Item Receipt balances in the Accounts Payable account. So please don't forget to split the former from the latter.

What does the Migration Control Account do?

You can create the migration control account as a current liability account.

The Migration control accounts will be used to record the relevant debits and credits from their corresponding transactions in the new system.

For example, a customer balance debited in the new system accounts receivable would have a corresponding credit recorded in the migration accounts receivable account. Do you see where I am going with this?

If you’re a non-accounting person reading this, then you're recording how much your customer owes as a balance in the new system. And to adhere to the double entry accounting principle, every debit has to match with a corresponding credit. This means you have to put the credit somewhere. In this case the migration control account. Make sense?

The migration control account keeps a record of the balances from your old system at the time of the migration. The objective is to get the aggregated balance of the migration account to zero.

The notional ‘opening balances’ in your new system are recorded using a general journal. I strongly suggest you record in the general journal and in the working paper what this balance is. I mean the customer, and each of the underlying transaction IDs. I’m referring to the Invoice number.

I also suggest you create a classification you can add to each type of journal, i.e. ‘migration AR’. This will help you follow the trail of any discrepancies, and tell you what the journal was for.

A reliable accounts receivable migration journal would contain a debit and credit for each customer. So if you’ve hundreds of customers and open invoices you’d need to create a large journal. The good news is there’s an ‘Upload Journals’ import sheet in the Setup>Import Data section of your system.

If you're an accountant, you will have spotted I’m referring to the simple process of moving the unadjusted trial balance and the underlying transaction detail to the new system.

Also, you’ll understand why, and how over time when the closing trail balance is determined, the migration control account will be reduced to zero, and if it is not then how useful the detail in the migration control account will be in debugging the problem.

If you’re not an accountant, here’s a simple explanation:

So, you have an open and unpaid invoice in your old system. The payment for this invoice is received in your new system. The amount owed is in your new system. The migration control account maintains the integrity of the accounting relationship of the two transactions. (I promise you).

“What about aging debtors and creditors?”, I hear you whisper. You can run the aging reports in your old system, right? This is the map of what is open and needs to be transferred over. It also tells you what and to who you need to pay attention to.

How do I create/upload journal(s)?

You can bulk-upload journals using the Upload Journals template. You'll find this in Setup>Import Data>Upload Journals.

You need to know you can create journals that apply debits and credits directly to the Customer (AR) or Supplier (AP) account. See .

Good to know - you can reverse Journal entries. See .

General Journals
Reverse General Journal
Migration Control diagram