Financial File Import - Vendor Payments
When I import an OFX bank file I get a list of transactions where I can assign customer/vendor account and the GL account.
In my list I have a number of vendor payments which I'll need to apply to payables. What is the correct process in the file import screen to be able to apply the vendor payments to payables after I hit the create/update records button.
What happens at the moment is I chose the vendor and then choose 'accounts payable' GL account. It creates a cash disbursement and the associated transactions are CR bank and DR accounts payable which seems correct.
BUT, when I click 'apply' I get the following error message:
Error: A Cash Disbursement can not be applied to unpaid Payable records when the Debit GL Account is null or set to the AP Control Account.
If you are creating Cash Disbursements through the bank direct connect feature, you'll need to hit some other balance sheet/clearing account other than AP. Such as Prepaid Expenses. When you apply the Cash Disbursement to the Payable, that is the transaction that will reverse the balancde out of the clearing account, and reduce your AP balance.
You're right that this does not match what happens when you pay a payable directly. When you pay a payable directly, the Accounting Seed system "shortucts" the application process and the cash disbusement debits AP directly. You'll notice, in this cirumstance, if you look, that the AP Disbursement record which relates the Cash Disbursement to the AP does not have any transactions.
But when you manaually apply a Cash Disbursement to an AP the AP Disbursement *does* generate transasctions, so if you specify the AP Account on the Cash Disbursement, it will hit it *again* when you try to manually apply the Cash Disbursement to the AP.
Let me know if that answers your question :-)
Please sign in to leave a comment.