Solved

How to import Trial Balances for a Company configured "multi branch without balancing"

  • 28 December 2023
  • 1 reply
  • 53 views
F
Rank

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?

icon

Best answer by Laura02 28 December 2023, 18:53

View original

1 reply

Laura02
Rank
Badge +18

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

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved