When you import a transaction through the Import Wizard you have the option of selecting that the transaction was for:
- Cash Book only
- Debtors (customer has paid their account)
- Creditors (you have paid a supplier's account)
The case in question, "I have imported my transactions but now have payments against Creditors that I cannot allocate because I have not loaded the Creditor's Invoices." has occurred because the creditors' invoices have not been loaded.
It is highly recommended to establish and maintain the discipline of entering Creditors Invoices.
RULES
If you are using the Cash Book Import Function, only profile transactions as Creditor Payments if you are actually paying a 'loaded creditors invoice'.
Else just import the transaction as a Cash Book entry only.
SOLUTIONS
TO RESOLVE THE CREDITORS BEING PAID BUT NOT ALLOCATED
- Create entries to clear the Creditors Payments (Add Inv/Credit Note)
- These entries should be dated on the day the payment was made
- For previous years entries you will be warned but still process on the date of payment
- Allocate the payment against your new entry by either:
- Tag Bills to Pay (You can select the month you want to work with)
- Make a Payment where the option will see that there are credits to allocate and prompt you to do so
TO STOP THE ISSUE FROM HAPPENING AGAIN
- Go into Cash Book - IMPORT WIZARD
- Select "View/Edit Master Profiles"
- Select the button Filter - 'Creditors'
- Select each creditor and change the 'What is updated?" to 'Cash Book only'
From now on, imported transactions will not post to the Creditors Ledger.
If you should take up the practice of loading your Creditor Invoices, you will need to revisit the Master Profiles and set them up to allocate payments against Creditors.