Categories
Banking Import Data

Import / File Upload QBO, CSV, QFX, or OFX format

Categories
Banking Navigation Transactions

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

 

You can permanently delete bank downloaded transactions in QuickBooks Online (QBO).

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

To move from “For Review” tab to “Excluded” tab:

  • From the home page screen > Go to the left navigation bar Dasshboard
  • Click Banking
  • You’ll see the “For Review” 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 will be moved to the “Excluded” tab now.

You can permanently delete from the “Excluded” tab now.

To permanently delete-excluded bank transactions.

  • From the home page screen > Go to the left navigation bar dashboard
  • Select Banking
  • Select “Excluded” tab
  • Select Batch actions (drop-down arrow)
  • Select Delete
  • You can select to delete a transaction or multiple transactions here
  • Note: If you select UNDO it will move back to “For Review” tab.


How to permanently delete bank downloaded transactions in bank feeds


 
helpful videos

Categories
Bank Deposit Banking Navigation Other Transactions

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

Categories
Banking

Import credit card transactions from Excel CSV (.csv) file into QuickBooks Online

I highly encourage you to watch the entire video. You do not want to miss a step.

Please click here for more information on this topic.

Categories
Banking Expense Expenses Import Data

How to import credit card transactions from Excel CSV (.csv) file into QuickBooks Online?

The short video (below) will show you step-by-step instructions on how to import credit card transactions from Excel CSV file into QBO so that you will not import transactions the wrong way.

Confusion has to do with bank account field and Quickbooks field screen. It is the same field name for bank download as well credit card download. Users are importing a CSV file from credit card company and every transaction ended up being the opposite of what it should be…. expenses listed as credits (spent), credits listed as expenses (received).

Once you have downloaded transactions, there is no way to UNDO or delete downloaded transactions. You will have to move to “EXCLUDED” column and it will stay there forever which is not good.

So, I highly encourage you to watch the entire video. You do not want to miss a step.

import cc csv 1

import cc csv 2

import cc csv 3JPG

import cc csv 4

import cc csv 5

import cc csv 6

import cc csv 7

import cc csv 8.1

import cc csv 8.2

import cc csv 9

Categories
Banking

To transfer fund between accounts within QuickBooks

From the home page screen

  • Click Create (+) Sign
  • Under “Other” select Transfer

Here you can record the transfer, just click Save and Close when you’re done.

In this example (see screenshot photo for reference), it’s transferring $1,000.00 from Checking Account to Savings Account.

  • Transfer Funds From = Money coming out from that account
  • Transfer Funds To = Money going into that account
  • Transfer Amount = Amount transferred from one account to another account
  • Memo = To record transfer information. Indicate reason if necessary.
  • Balance = Existing QuickBooks Balance before this transfer recorded
  • Attachments = Attach bank receipt for record

from create + sign to transfer

sample transfer transaction

New QuickBooks Online Plus – How to enter various expenses in new QBO?

QuickBooks Online (QBO) Tutorial – Customer Invoice, Sales Receipt, Receive Payment, Bank Deposit

Categories
bank feed Banking

QuickBooks Online Bank Feed: How to import/export bank rules

Bank rules are great for controlling how incoming bank transactions are categorized before you accept them into QuickBooks. Rules save time and minimize typing mistakes!

This article explains how to import and export rules, which is convenient if you manage multiple companies (like accountants often do).

SOURCE: http://quickbooks.intuit.com/blog/how-to-import-export-quickbooks-online-bank-rules/#respond

Categories
Banking Import Data

QuickBooks Online: How to import bank transactions from Excel .csv file into QuickBooks Online?

Now, you can import bank transactions if your bank provides .csv (comma-separated values) file type. This is new improvement they have just made.

You will take the following steps to import bank CSV file:

From the home page screen > go to blue navigation bar on the left > select Transactions > select Banking under Transactions > click Update > select File upload

 

You can also import bank transactions directly from excel .csv file type into QuickBooks Online. Take these steps.

From the home page screen > go to blue navigation bar on the left > select Transactions > select Banking under Transactions > click Update > select File upload

This could be a huge time-saving task especially when bank do not provide a way to download old bank transactions but available in other formats. If you have bank statements in PDF format, you may be able to just copy and paste to Excel. You can also edit description data and make necessary changes in Excel spreadsheet. Once it done, save file type as Text CSV (*.csv). It takes the following columns to import from Excel:

Column 1 = date

Column 2 = description

Column 3 = spent as negative amount and received as positive amount

OR

Column 1 = date

Column 2 = description

Column 3 = spent as debit

Column 4 = received as credit

If the bank statement provides deposits and withdrawals in two columns, use four column format spreadsheet.

Once the bank file is uploaded into “New Transactions” section of bank feed, you can also add manage rules before transferring transactions to “In QuickBooks” section of bank feed.
 
You can watch this QuickBooks Online Tutorial Video for step-by-step training instructions.

 

1 bank1 csv
 

2 Save as Text  CSV type 

3 file upload 

4 select the file to upload 

5 select bank account

6 bank account quickbooks field 

Categories
Bank Register Banking Transactions

Where is the splits button in order for split transactions in the bank register screen?

There is no splits button in the bank register. So, you cannot enter split transactions in the bank register with QB Online like you can in QB Desktop.

However, what you could do is enter the transaction in the bank register using one account.

Select “Edit” button, add a transaction screen form will open, then you can use as many account as you need to split the transaction amount.

It is one more step to do it.

Edit Register

Categories
Banking

Bank feed NEW manage rules in QuickBooks Online

From the home page screen > blue navigation bar on the left > transactions > banking > update > manage rules

On the Banking page, you can set up rules to tell QuickBooks what to do with bank items that meet particular conditions. Rules help you control, customize, and automate how you use the Banking page in QuickBooks.

Even without rules, QuickBooks makes it easier for you to accept bank transactions quickly. When QuickBooks downloads your bank transactions, it does the following:

Cleans up cryptic bank descriptions

Suggests logical categories based on bank descriptions

Remembers changes you made before, and applies those changes to similar transactions

Looks for matches among the transactions you already entered into QuickBooks

Rules go beyond the automatic processing to give you a finer level of control. They scan downloaded bank items for certain criteria you specify, and then assign particular payees, categories, classes, locations, and more to them. Rules can even help automatically split items between categories and more.

You might not need rules, but for frequently downloaded items they can save you lots of time. Here are some sample rules:

Categorize expenses at Mountain Hardware less than $50 as Landscaping

Categorize expenses at Riverview Office Supply greater than $600 as Capital Expenditure

Split income from Lakeside Law Firm as 30% Services and 70% Products

Split expenses from Hillside Communication as $40 Utilities and the remainder as Office Expenses

Rules like these can save you from having to update categories and adjust transactions one by one.

Source Quickbooks Online Help

Bank Feed Rule Form