Skip to main content
A
Avio
September 11, 2023
Solved

Posting prepayments to supplier accounts from imported bank transactions

  • September 11, 2023
  • 1 reply
  • 0 views

Hi there,

I have Quickbooks set up to automatically import bank transactions from an Amex credit card.

Throughout the month, Google regularly charges the card with £500 whenever I hit a usage threshold, but I only get the invoice from Google at the end of the month.

So, when I am trying to post/match my credit card transactions from the Bank Transactions section, there is no invoice for me to match the payments to. I would like to post these transactions as unapplied payments to the supplier account, but I cant find any way to do this.
At the moment, I post each transaction manually in the supplier account, and the only way I can do that is to first create a supplier invoice for £0.01 at the beginning of the month, then click on Make Payment (from the Supplier Account section), enter the payment details, and then unselect the invoice, so that the payment is 100% unallocated. I then repeat this for each payment, until the invoice is received. Then I edit the £0.01 invoice with the correct details, and match all the unmatched payments to it.
This is very tedious, is there any way I can use a rule to just create unallocated payments from the Bank Transactions section instead?
Thank you for any suggestions

Best answer by GeorgiaC

Hello and welcome to the Community, Avio

 

You can post a payment on account from the for review tab of the banking screen by clicking onto the payment to expand > select the supplier on the drop-down > set the category to creditors. Complete any other fields here as you see fit and add.

 

This will then post as an unapplied payment to the suppliers account, where you can later apply it as the payment to the invoice (once you've received & entered this in QuickBooks). After entering the invoice, select Make payment and the transaction will appear under Credits where you can tick to apply. 

1 reply

G
GeorgiaCAnswer
September 11, 2023

Hello and welcome to the Community, Avio

 

You can post a payment on account from the for review tab of the banking screen by clicking onto the payment to expand > select the supplier on the drop-down > set the category to creditors. Complete any other fields here as you see fit and add.

 

This will then post as an unapplied payment to the suppliers account, where you can later apply it as the payment to the invoice (once you've received & entered this in QuickBooks). After entering the invoice, select Make payment and the transaction will appear under Credits where you can tick to apply. 

    A
    AvioAuthor
    September 13, 2023

    Hi Georgia,

    Thank you for your reply.

    This worked perfectly 🙂

    Terms & ConditionsAccessibility statement