#AMA | Ask QuickBooks Experts Your Questions About Banking

Hello, Has this event started.  What format will be used? Will we see everyones' questions, will there be a video?

I'm going to get things rolling with a question we often see in QuickBooks Online: "QBO stopped pulling in transactions from my bank. What do I do to get them to start pulling in again?"

Where do I see the ongoing conversation?

How do I post, payoff one line of credit with another?

 Hi there @KevyGo 

The ongoing conversation will be in this thread. You'll want to refresh the page to view any added comments.

Using Quick Start version, set up bank account with a link, on the original feed I set in a starting date of the end of the prior quarter. The transactions that were sent to me did not go back that a far. How can I get the previous transactions?

Hi Ami, I'd love to share some information on this subject.

Typically, when QuickBooks Online has stopped pulling in bank transactions, we recommend disconnecting and reconnecting the bank account. By doing so, QuickBooks gets a clean refresh of the connection. I've included some steps below to disconnect and reconnect the bank account. 

To disconnect: 

1. On the left navigation bar, hover your cursor to the Banking menu or Transactions menu and choose Banking.
2. Select your bank account.
3. Click the pencil icon, then press Edit account info.
4. Put a checkmark on the Disconnect this account on save checkbox.

Then, it's time to reconnect the bank account. Before reconnecting the account, you'll want to ensure you stipulate the start date. This way, you aren't pulling in any duplicate transactions. 

Here's how to reconnect: 

1. Open the Banking menu. 
2. Scroll to the account you need to reconnect, then select Link account. 
3. In the search field, enter the name of your bank.
4. Tap Continue. Then sign in to your bank with your user ID and password. 
5. Follow the on-screen steps. This might include security checks your bank requires. It could take a few minutes to connect.
6. Select the accounts you want to connect, then select the account type dropdown.

For additional information about this process, check out Connect bank and credit card account to QuickBooks Online. 

I hope this helps shed some light on any of our users facing this issue. Take care! 

I am concerned I may get duplicated transactions. 

For example:

set up the link about 12/20/2021

entered to start the feed as of 09/30/2021

only received transactions beginning 12/13/2021 ?!?!

have been successful in getting transactions up to today

would like transactions between 09/30/2021 to 12/13/2021

How can I get them without duplicating transactions between 12/13/2021 to date?

Hi @KevyGo

Great question!

Some banking institutions have limits on how far back you can go to upload transactions automatically. No worries, you can still upload those you need manually. Here’s how: Manually upload transactions to QuickBooks Online.

The article above has a great short how-to-video, as well as step-by-step instructions.

Essentially, you’ll:

1. Go to your bank website and get a CSV file from your bank register.
2. Review the file size, max is 350 KB.
3. Manually upload from the Banking menu in QBO.

Check out the article for details. Let me know if you have any other questions!

As it happens I did download the transactions from even further back, BOY 2021. So I have a CSV file (in Numbers).  I would want to include the TAG on these so as not to have to go through them twice.  I will go to the directions you mentioned. Will I be able to add the variable for the TAG to the CSV file before uploading.  Can you give me the list of fields QBO has for the entries?   Hope I asked that understandably.  Also, could I add the Payee and correct the category while it is in the CSV spreadsheet format?

@KevyGo

You can upload CSVs with either the following 3-column or 4-column format. These are the only columns QuickBooks can handle and this order.

Each bank formats CSV files differently. This means you may not be able to import CSVs from certain banks since files don't have the format QuickBooks needs.

The 3 column format

This format has a Date, Description, and Amount column.

The 4 column format

This format has a Date, Description, Credit, and Debit column.

There isn't an option to add TAG or categorize in the CSV prior to uploading. For more info, check out how to format CSV files in Excel for QuickBooks

Thank you very much.

When entering a check on the Expense screen How can I enter the product that I am paying for?

Thanks for joining our banking #AMA thread, Janet j2.

You can post payments against lines of credit with paper checks or credit/debit cards.

Here's how to create payment records with checks:

1. Set up the appropriate liability and expense accounts.
2. In your left navigation bar, use the + New button.
3. Under Vendors, click Check.
4. In your Payee field, choose or enter the name of your financial institution.
5. Pick the bank from your Bank Account drop-down list.
6. In its Category details section, hit Line of Credit for Category Type, then enter the amount you want to pay down on your principal.
7. Use the Category field and choose Interest paid, then specify an amount you want to pay down on interest.
   
   

If you're paying your financial institution with a debit/credit card, you'll need to record the repayment as an expense and categorize it. You'll also need to be sure to split the expense between principal and interest in your Category details area of the check creation screen.

I'd also recommend consulting with an accounting professional in case you have any questions. In the event you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified able able to provide helpful insights for driving your business's success.

Please don't hesitate to send a reply if there's any additional questions. Have a wonderful day!

@KevyGo 

You can enter the product in the category and details section of the check or expense screen.

1. Select + New. Then select Expense.
2. Select the vendor. 
3. Choose the account you used to pay for the expense.
4. Enter the date
5. In the Payment method field, select how you paid for the expense.
6. In the Category details section, enter the expense info. In the Category dropdown, select the expense account you use to track expense transactions. Then enter a description. Tip: You can also enter specific products and services in the Item details section to itemize the expense.
7. Enter the Amount and Tax.
8. If you plan to bill a customer for the expense, select the Billable checkbox and enter their name in the Customer field. Learn more about billable expenses.
9. When you're done, select Save and close.

All set!