Hi, I am doing an import bank transactions manually by uploading a CSV file. I have stated the beginning and ending balance, but when I create a new import bank transaction record for the same cash account, Acumatica doesn’t automatically set the beginning balance as the ending balance of the last statement. Could someone please explain clearly how this works? I would assume the system should’ve automatically detected last ending balance as the beginning balance for the current statement.
Solved
Beginning and Ending balance in Import Bank Transactions screen
Best answer by mblassingame35
Normally, it uses the data in the file to determine the beginning and ending balance. Since you are using a csv upload, it probably does not have this information and you would need to enter it manually. It does not automatically use the ending from the last one.
+4Normally, it uses the data in the file to determine the beginning and ending balance. Since you are using a csv upload, it probably does not have this information and you would need to enter it manually. It does not automatically use the ending from the last one.
Hi
+4No, it does not automatically set the beginning balance. The only way it automatically populates those is if the information is in the file.
Thanks for confirming that! Now, I will create an import scenario for the client via CSV data provider and include beginning and ending balance in the CSV template:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.