How to import Bill payment via iif

Derek38 · ‎January 16, 2024

Hi -

I am trying to import bill payment to QuickBooks Accountant Desktop. I want to make sure the billpayment are hitting the bills that are already in the QB. Does anyone know how can i structure the iif file to achieve this?

Thanks.

best

BigRedConsulting · ‎January 16, 2024

Unfortunately it can't be done. However, you can import the bill payments as standard checks that use the AP account in the detail area of the check.

4Gal · ‎January 16, 2024

@Derek38

Prepare your Bill Payment data with the following template in Excel

Payee

Transaction Date

Apply to Bill RefNumber

Payment method

Bank Account

Credit Card Account

RefNumber

Amount

Memo

Discount Amount

Discount Account

Discount Class

To Be Printed

Exchange Rate

Bell Telephone

01/10/2020

123

Check

Checking

101

1500

Y

Ajax Lumber

01/10/2020

400

Check

Checking

102

1500

Y

Parts R Us

01/10/2020

1200

QuickBooks Credit Card

CC1

85

N

then use the importer tool to proceed. It's a one time license tool.

https://get.transactionpro.com/qbd

Topics

Training

Community

Resources

How to import Bill payment via iif

How to import Bill payment via iif

How to import Bill payment via iif

Need to get in touch?