How to Import Trial Balances

Background

When starting with Patriot Accounting, you’ll have the option to enter your current trial balances in Patriot with a beginning balance date in the software. You can enter the trial balance by exporting your trial balance report from your former software or creating your spreadsheet to upload into Patriot Accounting in the startup wizard.

For more information about how to transfer your accounting data, check out our help article, “Transfer Your Accounting Data.”

Steps to Import Trial Balances

1. For an easy import, make sure you have all of your accounts entered in Patriot Accounting. You can check these on the import page, where Patriot will list all accounts and total numbers.
2. Click the arrow to expand each account and view the details. 
3. To add a new account, click the “+Add a New {Type} Account” link located at the bottom of each section.
4. If there are unassigned accounts, you will need to map the columns and accounts from your spreadsheet to the corresponding columns and accounts in the accounting software by selecting from the dropdown.
   • If the account does not need imported, select “Do Not Map This Account.” Add a new account by clicking the “+Add a New Account”  link.
5. Drag and drop your file or choose the file from your computer and click the “Save and Continue” button.
6. Trial balances match: When you’ve mapped all of your unassigned accounts, click the “Submit Trial Balance” button.
7. Trial Balances don’t match:
   • Your trial balance must have equal debits and credits. If the totals don’t match, you’ll need to fix the entries so that each account balances correctly as of your beginning balance date.
   • Click the back button to make changes. You can edit each account’s debit and credit balance, change your beginning balance date, or add new accounts on your trial balances if you need to make corrections.
   • You could also click “Save” to save your progress, but beginning balances won’t be imported into your accounting software until the debits and credits are equal. Once they match, submitting the trial balance will complete the import.
     

Was this article helpful? *

• Yes
• No

Comments:

Submit

Your feedback will not receive a reply. If you have a specific issue, please reach out to our support team here.