Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
asm212
Level 2

My PNC HELOC does not show charges on the activity that is downloaded to QBO. The downloadable statement does show the monthly intrest charge month but does not go to QB

So every month I have Payment received downloaded from the heloc, and payment made from my bank account. Where is the charge suppose to come in - am i suppose to add it manually? Has anyone come across this issue and found a solution?
6 Comments 6
RenjolynC
QuickBooks Team

My PNC HELOC does not show charges on the activity that is downloaded to QBO. The downloadable statement does show the monthly intrest charge month but does not go to QB

Hello, asm212.

 

I'll share some steps on how you can get the charges downloaded.

 

If you don’t see a transaction you expect to see, let's manually update your bank by following these steps:

 

  1. Go to the Banking menu or Transactions menu.
  2. Click the Banking tab.
  3. Select the Update button.

Otherwise, check around the Banking menu or review your account history. The transaction may be stuck somewhere. You can follow step 2 or 3 in this article: What to do if you can’t find downloaded transactions in QuickBooks Online.

 

If in case the downloaded transaction includes the charge, you'll want to record a bank deposit in your QuickBooks Online account deducting the fee. This way, you can just match both transactions.

 

To include the fee in a deposit, please check out the steps under the Include bank or processing fees section in this link: Record and make bank deposits in QuickBooks Online.

 

As for categorizing and matching your downloaded transactions, you can find the instructions here

 

Please feel free to reply to this post if you'd like some assistance with other task in your account. I'll be happy to guide you through the process. Take care and stay safe.

asm212
Level 2

My PNC HELOC does not show charges on the activity that is downloaded to QBO. The downloadable statement does show the monthly intrest charge month but does not go to QB

this is hard to understand:

 

If in case the downloaded transaction includes the charge, you'll want to record a bank deposit in your QuickBooks Online account deducting the fee. This way, you can just match both transactions.

 

can you explain it different?

 

the transaction will not be downloaded from PNC because they don't included it in the "activity" tab only in the monthly statement.  I think it is a failure on their part, tbh

SarahannC
Moderator

My PNC HELOC does not show charges on the activity that is downloaded to QBO. The downloadable statement does show the monthly intrest charge month but does not go to QB

Hello there, @asm212. Thanks for getting back to us.

 

I'd like to provide additional details about the charges that aren't showing up in the system. 

 

QuickBooks only depends on transactions imported from PNC. When a bank imports transactions deducted by fees, QuickBooks has a way to handle them. This is to record the fees in your QuickBooks Online and keep your bank data accurate. This way, you'll be able to reconcile your account easily.

 

Still, I'd recommend following the suggestion shared by my colleague RenjolynC. You can use your monthly statement as a reference when recording a bank deposit for the charges. Create an invoice and record the payment. Once done, record the fees. You can follow these steps.

 

  1. Click + New.
  2. Select Bank Deposit.
  3. From the Account ▼ drop-down, choose the account you want to put the money into.
  4. Mark the payment you've recorded above.
  5. Scroll down to the Add funds to this deposit section and enter the amount fee as a negative number.

 

You can use these article to learn more about handling bank transactions in QBO:

 

 

Please let us know if you still need assistance. We'll be around to help you anytime, asm212. Stay safe and have a good one.

asm212
Level 2

My PNC HELOC does not show charges on the activity that is downloaded to QBO. The downloadable statement does show the monthly intrest charge month but does not go to QB

Ok thank you.  I was hoping it wasn't going to have to be a manual invoice entry.  Is there a way to set up a recurring invoice in QBO? I am trying to automate my monthly bookeeping as much as i can and ofcourse banking with PNC is unfortunate, but maybe QBO has a work around?

asm212
Level 2

My PNC HELOC does not show charges on the activity that is downloaded to QBO. The downloadable statement does show the monthly intrest charge month but does not go to QB

is there an option to automate this invoicing and make it recurring every month?

 

I can see pnc is providing in sufficient data and I have reached out to them.  Unfortunately they are not a cutting edge bank and I do not expect them to be able to change their data feed to quickbooks.  I am therefore exploring work arounds with quickbooks to try to automate all my monthly transactions.

Angelyn_T
Moderator

My PNC HELOC does not show charges on the activity that is downloaded to QBO. The downloadable statement does show the monthly intrest charge month but does not go to QB

I appreciate you for getting back, @asm212.

 

Yes, QuickBooks Online (QBO) allows you to set up recurring invoices so you don't need to generate an invoice manually. I'm here to share with you how.

 

  1. Sign in to your QBO account.
  2. Go to the +New icon, then click on Invoice.
  3. Fill in the invoice details.
  4. Tap on Make recurring between Print or Preview and Customize.
  5. Enter the recurring invoice details, then tap on Save template.

 

Alternatively, you can create the template through the Gear icon. To learn more about this, open this article: Create recurring transactions in QuickBooks Online.

 

Just in case you need help with modifying a recurring transaction template in the future, use this link as your guide: Edit a recurring template.

 

If you have any other follow-up questions about setting up recurring invoices in QBO, let me know by adding a comment below. I'm more than happy to help. Keep safe!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us