Hello, anyone have the format required for Voucher import using excel?
Thanks.
If you go to the voucher import screen under Accounting> A/P> Voucher Import you can see the required columns there. Are you having any issues with the import that don’t seem to be working?
Thanks,
Cetec ERP Support
Yes, I can’t seem to find the invoices as posted. They were paid and I see that side of the transaction, but the debit to expense and credit to AP is missing.
What vouchers are you seeing that have this issue? You imported those vouchers? What was your file formatted as?
Thanks,
Cetec ERP Support
there were 2 excel files imported.
The VOUCHER side (debit expense, credit AP) seems to be missing from 98 out of 107 vouchers. I can’t query on the voucher itself, nor can I find the charge in the expense account. In ANY month.
The PAYMENT side (debit AP, credit CASH) is fine, so the result is that I have about a $13k debit to my AP where it should be zero.
Can you help with this? I mean can you access my site? In the Trial Balance, you need to look at account 212000 (Accts Payable). For example, you’ll see Entry # 5889 is a payment for a lot of vouchers, but the vouchers are nowhere to be found (unless they got posted somewhere other than what we put in the upload). Please tell me I missed a step somewhere.
I am going to escalate this to our accounting team and get back to you.
Thanks,
Cetec ERP Support
Murray,
Were there any Vendors included in the Voucher upload?
Best,
CETEC ERP Customer Support
Yes. These are vouchers included in the monthly visa payment, so we assigned them all to the same vendor (one vendor per payment - there were 2 payments, 2 uploads). One was called “MW VISA” and the other was “SB VISA”.
Murray,
Possible that there is another issue with the file uploads causing the Voucher ledger splits to not populate. I will send you direct email so that you can email us the upload files used in upload to CETEC and we’ll take a look.
Best,
CETEC ERP Customer Support