How do I permanently delete “Excluded” transactions in bank feeds?

 

You can permanently delete bank downloaded transactions in QBO now.

In order to permanently delete a bank downloaded transaction (or multiple transactions) from the banking center, you will first need to move it from “New Transactions” tab to “Excluded” tab.

To move from “New Transactions” tab to “Excluded” tab:

  • From the home page screen > Go to the left navigation bar
  • Click Transactions
  • Select Banking. You’ll see the “NewTransactions” tab, click the checkboxes to the left of the date for the transactions you want to exclude.
  • Once you’re done, click the “Batch Actions” drop-down arrow and select “Exclude Selected.”The transactions move to the “Excluded” tab.

excluded

You can now permanently delete from “Excluded” tab.

To permanently delete-excluded bank transactions.

  • From the home page screen > Go to the left navigation bar
  • Select Transactions
  • Select Banking
  • Select “Excluded” tab
  • Select Batch actions (drop-down arrow)
  • Select Delete
  • You can select to delete a transaction or multiple transactions

Screenshot 2015-09-10 08.55.15


How to permanently delete bank downloaded transactions in bank feeds


 
helpful videos

How do I match transactions when bank feed deposits (from Stripe) are net and not gross

This is what you need to do!
First, when you create sales receipt or invoice > choose deposit to “Undeposited Funds” account, not bank account.

(I am giving lengthy steps, but it moves real fast)

Let us start from your banking center.

Find the deposit amount you want to match.

Highlight and click once. Transaction screen will expand.

Look for “Find Match” or “Find other match transactions.”

It will take you “Deposit” screen.

Select transactions to match (check customer payments). You are still looking at the gross level payments.

Getting closer, next step is where you make adjustments for Stripe fees.

Pull down “resolve difference” arrow and select “Add New Transaction.”

Select “Add New Transaction” and screen with expand with “Add New Transaction” section

You will also notice resolve difference amount which should be the same amount as Stripe Fees.

Go to “Add New Transaction” section

This is where you will enter Stripe fees.

Select account category (most likely merchant service fee expense account)

Enter negative amount for fees (same as resolve difference amount. example for ten bucks -10.00).

Save. Screen will disappear and it is posted to QuickBooks.

Back to banking center again!

If this does not work (because it was downloaded as bank transfer type), you will need to take manual route.

Bank Deposit (create + sign > other > bank deposit) > check payments > add fees to new transaction section as a negative amount. Same steps above.

Go back to banking center > now you should see green match sign > select match > done.

Click on the screenshots below to enlarge them
1receive_payment

2deposit

How do I download banking transactions into quickbooks from the months before I started using the QBO program

First you will need to download QuickBooks format file (QBO, QFX, OFX only) directly from the bank account to computer hard drive.

From the blue navigation bar on left > transactions > banking

You are now at the bank feeds section of the QBO area. Select bank account to download these new transactions.

Go to upper right (next to “Add Account” blue button)> select “File Upload” from pull down selector (“Update” is default)

It will take to next “Upload Bank File” screen > “Select the file to upload” from your computer hard drive. It goes through upload process. You should also all the bank downloaded under “New Transactions” area.

See attached screenshot photos for guidance.

Upload bank file QFX QBO OFX

upload file from bank feed
 
helpful videos
 

 

[table id=39 /]
[table id=37 /]