OOrgFilesWEB
Help
OrgFiles Web demonstration A fictional firm with three sample engagements (one with French statements), shared with other visitors and rebuilt every night. Try anything inside an engagement. How it worksTalk to B2B

HELP · USER MANUAL

9. Getting the trial balance in

Choose one of three ways. All three show you a review screen first. Nothing is saved until you confirm.

Which balance to bring in

Bring in the client's unadjusted balance, the figure from their own books before your entries. It becomes the account's Transactions amount. Posting your adjusting entries then adds to it. Re-importing later keeps any adjusting entries you have already posted.

Option 1: CSV file

Click Accounts › Import CSV.... A three-step wizard opens.

  1. Select Trial Balance CSV File. Browse for the file. Set the delimiter, and say whether the first row is a header.
  2. Map CSV Columns. Match your file's columns to OrgFiles fields. Account Number and Account Description are required. Optional fields are Opening Balance, Transactions, Adjustments, Final Balance, Prior Year Balance, Map Number, Account Type, and Normal Balance. Matching columns are suggested for you.
  3. Preview & Validation. Check every row. For each new account, pick its Statement Type and Normal Sign, pre-filled from your file when it had those columns. Existing accounts are shown as "READY (existing)", and their classification is never changed. The footer shows total debits and credits so you can see whether the file balances.

Use a single balance column with debits positive and credits negative. Click Finish to import.

Option 2: QuickBooks Online

Click Accounts › QuickBooks....

  1. Enter your Client ID and Client Secret, both from an app registered on Intuit's developer site (developer.intuit.com), and click Save Credentials. The firm shares these. Tick the Sandbox box to practise on Intuit's test company first.
  2. Click Connect.... Your browser opens. Sign in to QuickBooks and approve. This links this one engagement to one QuickBooks company.
  3. Click Pull Trial Balance from QuickBooks... whenever you want fresh numbers. A review screen lists each account with its guessed statement type. Correct any guess, then click Import.

Option 3: Xero

Click Accounts › Xero.... It works the same way, with credentials from developer.xero.com. If you authorize more than one Xero organisation, OrgFiles asks which one belongs to this engagement. Balances come from Xero's trial balance report as of today.

For both integrations: the pull is on demand, not a live sync. OrgFiles only reads from QuickBooks and Xero, and never writes anything back. The pull is blocked while the engagement is locked.

After any import

  1. Open Accounts › Chart of Accounts and check that every new account has a Map No., Group, and Class.
  2. Open Reports › Trial Balance. The debit total must equal the credit total. If it does not, a balance is missing or has the wrong sign.