I just discovered that in a Multi branch company “without balancing configuration” that the TB import feature does not provide the Branch as a column in the mapping so that the P&L can be imported by the appropriate Branch, GL Account, and Subaccount. This TB feature assumes that all branches will balance when imported individually when it will not balance. The sum of all Branches Trial Balances being imported for Balance Sheet and P&L will balance but not a given branch. How do I import TB for this multi branch not requiring balancing scenario?
Solved
How to import Trial Balances for a Company configured "multi branch without balancing"
Best answer by Laura02
Hello Frank,
The Trial Balance for multiple not-balancing branches may be imported as a Journal entry in Journal Transactions screen.
If you are importing trial balances for multiple periods, the first “Balance forward” entry will contain ending balance for each branch/account/subaccount.
Subsequent months will contain Net Debit or Net Credit by period for each branch/account/subaccount, from the prior system. If it’s easier, you may also enter subsequent periods with total debit on one line and total credit for each branch/account/sub on a separate line.
Laura
1 person likes this
+19Hello Frank,
The Trial Balance for multiple not-balancing branches may be imported as a Journal entry in Journal Transactions screen.
If you are importing trial balances for multiple periods, the first “Balance forward” entry will contain ending balance for each branch/account/subaccount.
Subsequent months will contain Net Debit or Net Credit by period for each branch/account/subaccount, from the prior system. If it’s easier, you may also enter subsequent periods with total debit on one line and total credit for each branch/account/sub on a separate line.
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
1 person likes this
+11Effective Acumatica 23R2, you can now import a trial balance for companies with branches not requiring balancing. See the release notes here: https://help-2023r2.acumatica.com/Help?ScreenId=ShowWiki&pageid=e15dd6a8-25b7-456b-a5a2-390b7e268887
Megan Friesen, Contego Software Solutions, Canada
1 person likes this
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.