(610) 444-2597 | (302) 428-0126 | (717) 341-1738 info@paisleysolutions.com

Entering Batch Transactions

To get started, follow these steps in the order shown.

  1. From the Accountant menu, select Batch Enter Transactions.
  2. From Transaction Type drop-down, choose the transaction you need to enter. In all supported versions of QuickBooks, you have the option to enter multiple Checks, Deposits, Credit card charges or credits, Invoices, Credit memos, Bills and Bill credits
  3. Select the appropriate bank/credit card or AR/AP account from the drop down arrow. You can also choose Add New to set up the account.
  4. Open the spreadsheet containing the transactions to paste into QuickBooks.
  5. Arrange the columns in your spreadsheet to match the column order in the QuickBooks Batch Enter Transactions screen.
  6. Highlight the transactional information, right-click it and select Copy.
  7. In the Batch Enter Transactions screen in QuickBooks, right-click the first date field in the list and select Paste.
  8. The information from the spreadsheet displays in the Batch Enter Transactions screen.
  9. Continue adding all transactions.
  10. Select Save Transactions then Yes to save.
  11. A window displays the number of transactions saved. Select OK to finish the import.

You cannot export batch transactions but you can copy multiple transactions from one company file to another in a form that can be imported using the enter batch transactions feature.


Memorized Reports

Create a memorized report
  1. From the reports window, select Memorize.
  2. On the Memorize Report window, type in the name you want to assign the report. Note that you need to enter a new name when you are saving a new memorized report. If you want to overwrite a previously saved report, use a name similar to it.
  3. (Optional) Put a check mark on the Save in Memorized Report Groupbox if you want to save the report on a specific report group (Accountant, Banking, etc…)
  4. (Optional) Put a check mark on the Share this report template with others. When you check this box, your report template will be accessible to other QuickBooks users when they go to the Contributedtab in the Report Center.
  5. Select OK.
Access a memorized report

There are several ways to access and open memorized reports.

From the Report Center:

  1. Go to the Reports menu and select Report Center.
  2. On the Report Center window, select the Memorized
  3. On the left panel, choose the appropriate group. If you didn’t assign a report group when you memorized the report, choose Uncategorized.
  4. Double click the report to open it.

From the Memorized Report List:

  1. Go to the Reportsmenu and select Memorized Reports then Memorized Report List.
  2. On the Memorized Report List window, double click the report.

From the Reports menu:

  1. Go to the Reportsmenu and select Memorized Reports.
  2. Select the report.


Linking Bank and Credit Card Accounts to QuickBooks Desktop

  1. From the QuickBooks Banking menu, select Bank FeedsSet Up Bank Feeds for an Account.Note: Check if your bank supports Online Banking in QuickBooks. Go to Banking > Bank Feeds > Participating Financial Institutions.
  2. In the Enter your Bank’s name field, enter the name of your bank. Note:as you type, QuickBooks displays possible matches.
    • Direct Connect: To set up account for Direct Connect, you must first apply for online services through your bank. If you use more than one account you may have to apply for each one separately. The bank will provide you with your login credentials once your application is approved. Contact your Financial Institution (FI) for details. If your bank offers Direct Connect service, you will be redirected to a window providing you the option to enroll in the service.
      • If you want to enroll, select the enrollment site link and you will be redirected to the bank’s website. Note: banks charge for Direct Connect service.
      • If you do not want to enroll, you will be given the option to manually import transactions.
      • If you have previously enrolled in Direct Connect, select the Continue In the next window, you can enter your Direct Connect login credentials.
        1. Enter your Online Banking ID and Password.
        2. Select Connect. QuickBooks will connect to the bank’s server.
        3. Select the bank account you want to connect to QuickBooks.
        4. Select Finish after the process completes. You have successfully activated online banking.
      • Web Connect: If your bank only offers Web Connect, you will be redirected to a window providing steps to download transactions through Web Connect. Note:downloading transactions from the bank’s website and importing them into QuickBooks Desktop for the first time automatically sets up an account for online banking. Depending on your bank and the version of QuickBooks you’re using, you may be presented with options for Direct Connect, Web Connect or both.
  1. On the Link your Accounts screen, choose which bank account(s) to add to QuickBooks.
    • If you have multiple accounts (Savings, Checking, or Credit Card) available to connect to QuickBooks but only need one (Checking), then you can set up online banking just for it.
    • If the account is not yet in QuickBooks, select the Select existing or Create newdrop-down, then choose Create New Account.


Processing Credit Card Payments to QuickBooks Desktop

QuickBooks payments account processing is available from within QuickBooks Desktop, for supported versions linked to a properly configured payments account.

There are two ways to process a credit card in QuickBooks:

  • Receive Payment: applies to QuickBooks customers when invoices are used to provide products or services.

  • Enter Sales Receipt: applies to sales of products or services where no invoice is used.

Record and process credit card payment

Follow these steps to complete a transaction using the Receive Payment or Enter Sales Receipt window.

Note: When using Jobs with a Receive Payment and a stored credit card number, only the credit card listed for the actual Customer will be available. Although the subordinate Job(s) will allow a different card number to be entered, it will not appear when an actual credit card charge is processed for the Customer of that Job.

  1. Log in to the QuickBooks Desktop Company file linked to a working payments account.
  2. From the Customers menu, select Receive Payments (or Create Sales Receipts).
  3. When the payment window appears (Customer Payment or Sales Receipt), complete the customer/order information as expected. However, be careful to accurately submit the following items for proper credit card processing (if a supported USB card reader is attached, select the Swipe Card button in either of these windows):
    • Payment Method (Visa, MasterCard, American Express, Discover)
      Process Payment box must be checked when saving.
    • Card Number/Expiration Date
    • Amount of transaction
  4. When finished, select the Process Payment 
    Note: For Customer Payments that do not have an open invoice, a pop-up warning will appear notifying you of an overpayment. Choose OK to continue and a credit in the amount processed will appear for that customer when completed.
  5. Select Save & Close to complete the process.

Determine where the received payments are posted to

To check where the received payments are being posted to:

  1. From the top left of QuickBooks, select Edit and choose Preferences.
  2. On the Preferences window, select Payments and choose the Company Preferences tab
  3. Check if Use Undeposited Funds as a default deposit to account is checked or not.If it is, the payments are going to the Undeposited Funds account. If it isn’t, the payments are automatically being posted to the bank account.

Note: Since approved funds are typically deposited into your existing bank account within 2 to 3 business days, we recommend using Undeposited Funds to hold payments, until they’re ready to be deposited. To know more about Undeposited Funds, check out Understand how the undeposited funds account works.


If Merchant Services is already deactivated in the Company file, please ensure you uncheck the Process Payment box so you are not prompted to connect to Merchant Services.

As another workaround, you can try changing the Credit Card payment method to CASH in the Payment Method List. This will gray out the Process Payment box and prevent it from from being selected.