Skip to content

Set up accounting for a new shop

When your shop starts using Nexsyis for accounting, you set up the accounts Nexsyis posts to, choose a cutover date, and re-enter the work that’s still open in your prior system. This page lists each step in order and links to the detailed instructions.

Make these decisions with your accountant before anything is set up:

  • When revenue is recognized. Your company recognizes revenue either when a repair is marked completed or when it’s marked delivered. This is one setting for the whole company, and it decides when sales post to the general ledger (GL). Most shops choose delivered.
  • How detailed your chart of accounts is. For example, decide whether to track calibration, glass and paintless dent repair separately within sublet. It’s easier to start with more detail, because reports can roll accounts up.
  • One account per purpose, not per location. Don’t create a separate GL account for each shop. Use one account, such as parts inventory, and Nexsyis records which location each transaction belongs to.

Then prepare your prior system:

  1. Clean up the data: close old periods, remove duplicates, and reconcile AR and AP.
  2. Export your current chart of accounts with account numbers.
  3. Prepare the ending trial balance for the most recent closed month and fiscal year, and the GL detail for each fiscal year you’re converting.

Set these up in order:

  1. Financial categories. These are your chart of accounts in Nexsyis. For each financial category, you choose whether it can be used on AP invoices (APIN), AR adjustments (ARTR), non-AR payments (CACD) and journal entries (GLJE). See Set up financial categories.
  2. GL FinCat Settings. Identify the control accounts Nexsyis posts to automatically, such as Accounts Receivable and Inventory - Purchases.
  3. Banks and bank posting. Set up your bank accounts and how they post, along with fee reasons and the small balance write-off.
  4. Sales codes. Add or remove sales codes, set up estimate line conversions where needed, and assign each sales code its sales and cost of sales accounts. See Set up sales codes and financial categories.
  5. AR adjustment reasons. See Make an AR adjustment.
  6. Non-AR payment reasons. See Record a non-AR payment.

Before go-live, import the opening trial balance and GL detail, and check that the Nexsyis trial balance matches your prior system as of the conversion date.

All financial activity in your prior system stops on the cutover date, and Nexsyis starts the next day. For example, with a cutover date of April 30, transactions dated April 30 and earlier stay in your prior system, and transactions from May 1 are entered in Nexsyis.

Before the cutover date:

  • Complete the final month-end close in your prior system, including financial statements and the bank reconciliation.
  • Pay as much open AP as you can in your prior system.

After the cutover date, use your prior system only to pay AP invoices it already holds. Don’t enter new invoices or repairs in it.

Work in progress (WIP) is every repair that’s open at cutover. Re-enter it in Nexsyis in this order:

  1. Repairs in progress. Create a folder for each repair, import its estimate, and add the original repair order (RO) number. See Enter work-in-progress AR.
  2. Folder dates. Set the arrival, completed and delivered dates to match your prior system. See Set folder dates for WIP folders.
  3. Payments. Enter payments the customer or insurer made before cutover. See Enter work-in-progress AR.
  4. AP invoices. Enter the AP invoices for each repair so they match your prior system. See Enter work-in-progress AP.
  5. Labor already paid. Enter flag hours you’ve already paid technicians for. See Convert prior flag hours.
  6. Repairs that only have an AR balance. For repairs that are finished but not yet paid, create the folder for AR collection only, without a work order. Check that each AR invoice total matches your prior system’s AR aging report. See Remove a work order from an AR-only folder.

Have a manager review each re-entered folder: the folder summary, purchase orders and vehicle status. Scan the documents from your prior system and attach them to the folder.

WIP for purchases is automatic for every AP invoice attached to a folder.

When you enter an AP invoice:

Account Debit Credit
WIP Purchases Invoice amount
Accounts Payable Invoice amount

When you invoice the folder:

Account Debit Credit
Cost of Sales Purchase cost
WIP Purchases Purchase cost

So at any time, WIP Purchases holds the cost of purchases on folders that haven’t been invoiced yet. This happens in real time, with no manual entries.

If you use the flag system for labor, you can record the change in labor inventory at the end of each month:

Account Debit Credit
WIP Labor Labor amount
Labor Cost of Sales Labor amount

Date this entry the last day of the month, and reverse it on the first day of the next month. See Accrue payroll and labor inventory.

  • Week 1: Use GL Detail Inquiry to follow a few repairs from estimate to work order to invoice to GL posting. Run the P&L, AR aging and AP aging reports with different date ranges and filters. See Look up GL detail.
  • Weeks 2–3: Run your first month-end close. Reconcile GL cash to the bank statement, check that AR aging splits insurance and customer balances correctly, and spot-check AP aging against vendor statements. See Close the month.
  • Week 4: Compare your first Nexsyis P&L with the P&L from your prior system, allowing for any overlap. Revenue should match and cost of goods sold should be similar. Find the reason for any large difference.

If you move your locations to Nexsyis in phases:

  • Nexsyis is the financial system for each converted location from its go-live date. Your prior system continues for locations that haven’t moved yet.
  • At regular intervals, usually monthly, import a trial balance or GL summary from your prior system for the locations that haven’t moved, so Nexsyis can produce combined financial statements.
  • Keep separate bank accounts during the transition.

When you acquire a shop, decide up front whether you’re taking over only its work in progress or its AR and AP as well, and whether its accounts will be combined with yours or kept separate. Then:

  1. The seller runs final reports: WIP, AR aging, AP aging and the GL trial balance.
  2. Nexsyis creates a new location for the shop.
  3. The shop’s WIP, and its open AR and AP if you’re taking them over, are imported into the new location.
  4. Check the opening balances against the seller’s trial balance, and reconcile the seller’s bank balance to the opening cash in Nexsyis.
  5. From day 1, the shop enters new repairs in Nexsyis. Payments the seller makes on its old AP invoices are recorded in the seller’s system and imported into Nexsyis.