Skip to main content
Solved

Journal Transactions from Trial Balance Not Working


I am trying to import my initial balances, I have imported a Trial Balance but when I release it, it shows me entirely different numbers in some accounts and will not let me edit anything.  The Journal Transaction that is created is out of balance and there’s nothing that I see that I can do to get my initial balances in the system.

This is my import spreadsheet:

 

Best answer by Laura02

Also, an alternate method of importing the beginning balances is via GL Journal Transactions screen. Use “import from file” button above the transaction grid. For this method, separate debit and credit balances into two columns.  If the debit and credit totals match in your excel, they will match in Acumatica once imported. Again, skip over account 3131-0… it will take care of itself when the income/expense balances come into the system.

Laura

View original
Did this topic help you find an answer to your question?

5 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2137 replies
  • March 25, 2022

Hi @albalma  

When you posted the Trial Balance, did everything match? Were there any errors or expections?


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3037 replies
  • March 28, 2022

Hello @Albalma, If the sign of the trial balance is normal (setting in GL preferences), we don’t include the Net Income account when importing opening balances. We import assets, Liabilities (excluding YTD net income account: another GL Preferences setting) , Income and Expense only.  See if you can balance without your account 3131-0.

 

Laura


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3037 replies
  • Answer
  • March 28, 2022

Also, an alternate method of importing the beginning balances is via GL Journal Transactions screen. Use “import from file” button above the transaction grid. For this method, separate debit and credit balances into two columns.  If the debit and credit totals match in your excel, they will match in Acumatica once imported. Again, skip over account 3131-0… it will take care of itself when the income/expense balances come into the system.

Laura


  • Freshman I
  • 1 reply
  • July 7, 2022

Did you ever figure out what caused this?  I am having the same issue


  • Author
  • Freshman I
  • 9 replies
  • July 7, 2022

Hello, yes, but it's more of a workaround than a fix.  A fix is possible, but it requires closing all balanced entries for the initial year. Some other adjustments may be needed and when everything is right, then it works well.  It's important to keep in mind that these entries only create a journal entry to make all balances the ones we wanted.  It is possible to do this with a JE, but then it's slightly harder to make everything match. 

 

What I did was copy the JE that's created by the system and make a new one, then fix the balances so they're actually balanced. That worked, but without closing all balanced entries there will be issues later on.

 

Hope this helps,

 

Al


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings