How do I match a batch deposit for payment of an invoice and vendor refund deposit?

Example: My total deposit amount is $1,300, $1,200 for payment for the outstanding invoice and $100 for Insurance refund. From the Banking Review tab, find the Deposit transaction you want to match with customer payment plus insurance refund. Click the Deposit transaction row in question. Click the “Find match” radio button. Match transactions screen will… Continue reading How do I match a batch deposit for payment of an invoice and vendor refund deposit?

Quickbooks Online – how do I delete items from Banking For Review

From the Banking “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 moved to the “Excluded” tab from the “For Review” tab. To delete permanently: From the “Excluded” tab >… Continue reading Quickbooks Online – how do I delete items from Banking For Review

Bank feed populates all downloaded check transactions with the same Vendor

EXAMPLE: My bank feed populates all my downloaded CHECK transactions with the same Vendor. I change the vendor payee category on any given transaction it will change for all downloaded transactions in bank feed. There is no bank rule setup for this. Is there a way I can turn that off? Unfortunately, you can’t turn… Continue reading Bank feed populates all downloaded check transactions with the same Vendor

How to handle fees (Paypal and Square) deducted from customer payments in QuickBooks Online

This article deals with step-by-step instructions on how to manually recording fees (Paypal or Square) and then match the deposit transactions in bank feed —Review items from your bank and link each item to an existing record. EXAMPLE – Signed up for Square (or PayPal) so that I could accept credit cards. I will be… Continue reading How to handle fees (Paypal and Square) deducted from customer payments in QuickBooks Online

How to import credit card transactions from Excel CSV file to QuickBooks Online (QBO)

QuickBooks Online allows users to import their credit card transactions via Excel CSV (comma-separated values) files. It will allow importing date, description and amount columns. For the amount, you can use 1-Column field or 2-Column fields. It is recommended to use Debit and Credit with two columns excel file format to import. QBO will not… Continue reading How to import credit card transactions from Excel CSV file to QuickBooks Online (QBO)

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