Skip to content
NEWLAW.COM
+61 1300 495 281
Let’s talk

Data migration route

The Tussman Program to QuickBooks Online migration

The Tussman Program is a desktop accounting and billing system, and QuickBooks Online is a cloud one. This is a move of the books: chart of accounts, customers, open items and balances.

FromThe Tussman ProgramDesktop
  1. Billing: Carried across
  2. Firm accounts: Carried across
  3. Matters: Carried with mapping
  4. Contacts: Carried with mapping
  5. Documents: Carried with mapping
  6. Notes: Carried with mapping
  7. Time and expenses: Carried with mapping
  8. Trust money: Carried with mapping
  9. Templates: Carried with mapping
  10. Tasks: Confirmed in the analysis
  11. Custom fields: Confirmed in the analysis
ToQuickBooks OnlineCloud
  1. Calendar: Kept as a readable archive
Readable archiveNo place in QuickBooks Online
  • 2 carried
  • 7 mapped
  • 2 to confirm
  • 1 archived
What the two products hold. The analysis confirms it field by field.

What moves

What moves from The Tussman Program to QuickBooks Online

Each row is a kind of record The Tussman Program holds, whether QuickBooks Online has a place for it, and what is planned. On this route two kinds of record carry across, seven kinds need mapping, one kind has no place in QuickBooks Online and is archived and two kinds are confirmed in the analysis.

Records in The Tussman Program and their place in QuickBooks Online
RecordIn The Tussman ProgramIn QuickBooks OnlineWhat is planned
MattersMatters or cases, with their numbers, types, parties and statusHeldClient and matter IDs, alpha or numeric, up to 16 characters each.Has a place in partNo matter record; a matter is set up as a sub-customer or a project.Carried with mapping
ContactsClients, other parties and referrersHeldClients, plus contacts and persons related to each matter.Has a place in partCustomers and vendors only; other parties have no record type.Carried with mapping
DocumentsFiles stored in or linked from the systemHeld in partA list of documents for each client, each opened with a click.Has a place in partAttachments on transactions and customers; there are no matter folders.Carried with mapping
NotesFile notes, matter notes and contact notesHeldFree-form notes on each client and matter.Has a place in partA notes field on the customer and memos on transactions.Carried with mapping
CalendarAppointments, court dates and deadlinesHeld in partWith the Docket/Calendar module.No placeKept as a readable archive
TasksTo-dos and workflow steps assigned to peopleHeld in partTasks and reminders in the Docket/Calendar module.To be confirmedConfirmed in the analysis
Time and expensesTime and expense entries, billed and unbilledHeldTime and disbursements, billable and non-billable.Has a place in partTime activities can be imported against customers; they are not matter time records.Carried with mapping
BillingInvoices, payments and debtor balancesHeldBills, payments, credits and a master ledger for each client and matter.Has a placeInvoices, sales receipts, estimates and customer balances.Carried across
Trust moneyTrust or client account ledgers and balancesHeldRetainer and trust accounts for each matter.Has a place in partTracked through a trust bank account and a liability account in the chart of accounts.Carried with mapping
Firm accountsGeneral ledger, office account and payablesHeld in partWith the General Ledger, Accounts Payable and Checkwriting module.Has a placeChart of accounts, journal entries, bills, checks, deposits and bank data.Carried across
Custom fieldsFields and record types the firm added itselfTo be confirmedHas a place in partUp to 12 enhanced custom fields per form or profile type, in the Advanced plan.Confirmed in the analysis
TemplatesPrecedents, document templates and automationHeld in partUp to ten bill formats.Has a place in partInvoice and sales form layouts only.Carried with mapping

What the plans mean

Carried across
QuickBooks Online has a place for this kind of record. It is loaded there and checked against The Tussman Program.
Carried with mapping
QuickBooks Online holds this differently, or in part. Each field or value is matched to its place before loading, and you see the mapping first.
Confirmed in the analysis
We could not confirm this from the two products’ own material, so it is checked against your data before the plan is fixed.
Kept as a readable archive
QuickBooks Online has no place for it. It is exported in a format that opens without The Tussman Program and handed to the firm as a read-only archive.

The table states what the two products hold and what NewLaw plans for. It is not a promise that every record moves: that is settled against your own data in the analysis.

This kind of move

Books to books, agreed to the trial balance.

An accounts move has a clear test: the trial balance in QuickBooks Online on its first day equals the trial balance in The Tussman Program on its last. Getting there starts with the chart of accounts. The two systems number and group accounts differently, so each account is mapped to its counterpart, and the firm’s accountant signs off the mapping. Customers, suppliers and open invoices follow, each tied back to an aged report from the old system.

History is the choice. The new books can start from opening balances and open items only, which is quick and clean, or take a period of transactions, which lets comparative reports run. Older years are usually kept as reports and a read-only copy of The Tussman Program. Time entries and rates move if QuickBooks Online has a place for them. The cutover is set for a period end, after the last bank reconciliation, so the two sets of books meet at a point both can prove.

The Tussman Program runs on the firm’s own equipment, so the data is collected there: a copy of the database and the folders its documents sit in, taken with the firm’s IT provider or over a remote session. QuickBooks Online is hosted by its maker, so loading depends on the import tools and access it provides. The old machine is kept, read only, as the fall-back record.

Where the data is now

A Tussman firm’s records are compact: one folder holds the clients, matters, charges, payments and bills, sometimes going back decades. The move takes unbilled charges, account balances, retainer and trust balances and the client and matter list, and checks each against the program’s own reports. Whether billed charges were ever archived or purged is established first, since it changes what can be reconciled.

  1. One folder holds it all

    Program and data live in the same folder, by default c:\tp9, and network users run it from a shortcut to that folder. The vendor’s own way of moving it between computers is to copy the folder. A copy taken with everyone logged out is therefore a complete source, and the trial load is made from it.

  2. IDs chosen by the firm

    Client IDs can be numeric, alphabetic or mixed, and the manual suggests using the client’s name as the ID. So an ID may be SMITH, not a number. Those work as references but not as matter numbers in most systems. The firm chooses a numbering scheme for the destination, and the old IDs are kept beside it.

  3. Billed charges stay unless purged

    Once billed, charges move to a Billed Charges file and stay there, so old bills can be reprinted exactly. They can be archived to a separate BTRAN file or purged, though the manual advises against both. Whether that was ever done decides how far back the detail goes, and it is checked before history is promised.

  4. Finalised and unfinalised bills

    A bill is marked as billed by finalising it, and any finalised bill can be unfinalised, changed and regenerated. Before the last extraction every bill the firm means to send is finalised. A draft left unfinalised would arrive as unbilled work, and the client could be billed for it again.

  5. Retainer and trust per matter

    Each matter can carry a retainer account and a trust account, with retainers applied to bills automatically and a replenishment request when the balance runs low. The two are different kinds of money and are mapped separately. With the general ledger module, the trust cheque register is another figure the load must agree to.

More about moving off The Tussman Program

Where it is going

QuickBooks Online is a ledger. Loading a law firm into it means deciding what the firm’s clients, matters, invoices and client money become in a system that has customers, projects and accounts. Records with a financial meaning find a place. Documents, emails, court dates and matter notes do not, and those stay in a practice system or document store beside it.

  1. No matters, so choose a stand-in

    A client becomes a customer. A matter becomes a sub-customer, or a project on the Plus and Advanced plans. Sub-customers can nest four levels deep. The choice affects every invoice and report afterwards, so it is made once, before loading, and applied to open and closed matters alike.

  2. Lists load before transactions

    Intuit’s import expects the chart of accounts first, then customers, vendors, employees, classes, locations, and products and services. Only then do invoices, bills, journal entries and time activities go in. Intuit says a spreadsheet must have fewer than 1,000 rows, so a firm’s history is loaded in batches and counted batch by batch.

  3. Client money through the accounts

    Client money follows the method Intuit documents, through the chart of accounts. A trust bank account and a liability account are created, and each client’s opening balance is posted against their customer record. Its Australian page also advertises trust records, and what they cover is confirmed in the analysis. Whether that meets the trust rules applying to the firm is for its accountant or regulator to say, before loading.

  4. Old invoices or opening balances

    Invoices can be imported, and each needs a customer and a product or service that already exists. Loading years of paid invoices also posts income into past periods. One approach is to bring unpaid invoices across as invoices and everything older as opening balances by journal, with the old system kept for the detail. The firm’s accountant chooses.

  5. What has no home

    Parties other than the client, matter descriptions, court dates, file notes and documents have no record type here. A file can be attached to a transaction or a customer, which suits a copy of a bill, not a matter file. The analysis lists each of these with where it will live instead.

More about moving into QuickBooks Online

How NewLaw runs it

Four steps, in this order.

Trust money moves on this route, so the trust cutover gets a rehearsal of its own.

  1. Analysis

    We read what The Tussman Program holds and how its records link, then agree with you, field by field, where each piece will sit in QuickBooks Online. Anything with no place there comes across as a note or stays behind, and you see which before the move.

  2. Clean-up

    Duplicate contacts and matters are merged where they can be identified, and inconsistent entries are put into one format, in The Tussman Program, before extraction. It is not always possible to find every one, so some may carry across.

  3. Trial load

    The data is loaded into QuickBooks Online as a trial and checked against The Tussman Program: record counts, trust and debtor totals, the links between records, document dates. Exceptions are listed for you to decide.

  4. Cutover

    Changes in The Tussman Program are frozen for an agreed window, the data is collected a final time and QuickBooks Online goes live over a weekend. The trust and financial cutover is rehearsed on a full trial load first, because it cannot be re-run the way a document load can. The Tussman Program is kept read only as the fall-back record.

Fixed price, agreed after the analysis. How NewLaw moves legal data

Start

Start this migration

Tell us what is in The Tussman Program and roughly how much of it. The first step is the analysis, and the price is fixed once it is done.

Step 1 of 5

Step 1 of 5: Start with the route

Moving fromThe Tussman Program
Moving toQuickBooks Online

The route comes from this page. Four short steps follow. Nothing you send commits your firm to anything.

What happens after you send it

  1. A free first call

    We go through your answers with you and ask about anything they leave open.

  2. An analysis of what The Tussman Program holds

    What is in it, how its records link, and where each piece would sit in QuickBooks Online. Anything with no place there comes across as a note or stays behind, and you see which before the move.

  3. A fixed price in writing

    Set after the analysis, so it reflects what is in your data. You have it before any work starts.

Beyond the data

Setting up QuickBooks Online

Loaded data is not yet a working system. This is what NewLaw sets up in QuickBooks Online, beyond the migration, so that people can work in it from the first day.

Setting QuickBooks Online up for a law firm is mostly accounting design. The chart of accounts, the way clients and matters appear as customers, the products and services behind each invoice line and the handling of client money are all decided before the first transaction is posted. If a practice system will feed it, that connection and its account mapping are part of the same work.

Set-up decisions in QuickBooks Online

  • Chart of accounts, including trust bank and trust liability accounts
  • Convention for clients and matters as customers, sub-customers or projects
  • Products and services for fees, disbursements and retainers, mapped to accounts
  • User roles and what each person can see or post
  • Connection to the firm’s practice management or time recording system
  • Invoice layout, numbering, tax codes and payment terms

Questions

The Tussman Program to QuickBooks Online: what firms ask

Closed and deleted clients: what comes across?

Closed clients stay in the data and can be loaded as closed matters. A client marked deleted is still there until someone runs the purge, after which it is gone. The analysis counts open, inactive, closed and deleted files so the firm can see what exists before choosing what to bring.

We use the cloud-hosted version. Can the data still be reached?

The hosted version is the same program running on a remote server, with the firm’s copy moved there from its own computer. A backup can be made from inside the program in the usual way. How that backup gets from the hosted server to the firm is arranged at the start.

Can we move the general ledger too?

If the firm bought the general ledger module, it holds cheque registers for office and trust accounts, vendors and the financial statements. Balances move as an opening journal, into the destination or into a separate accounting package. Vendor 1099 totals for the current year are carried as figures.

Do trust balances in The Tussman Program have a place in QuickBooks Online?

In part. Tracked through a trust bank account and a liability account in the chart of accounts. The analysis sets out which trust records have a place in QuickBooks Online and which are kept as an archive, and the trust cutover is rehearsed on a full trial load before the real one.

What happens to records QuickBooks Online has no place for?

On this route that is calendar entries. They are exported from The Tussman Program in formats that open without it, spreadsheets and PDFs, and handed to the firm as a read-only archive. You see the list before the move.

What has to be decided before The Tussman Program data is loaded into QuickBooks Online?

Matters, contacts, documents, notes, time entries, trust ledgers and templates are carried with mapping, so each mapping is agreed with you first. Tasks and custom fields are confirmed in the analysis. The firm also sets the cutover date and how much financial history comes across as live records.

Where to start

Before and after the move.

Choosing the system comes before a migration. Setting it up and putting AI to work come after.

How we do itDiscovery to rollout, step by step

The Tussman Program and QuickBooks Online are the names and marks of their owners, used here only to identify the two systems.

Moving from The Tussman Program to QuickBooks Online?

Tell us what you are moving. You get a plan and a fixed price after the analysis.

We reply within one business day.