✦Template Printable Ideas Insights

How to Print Deposit Slip in QuickBooks

By

Managing accounts and tracking financial transactions has been made significantly easier with QuickBooks, but at times, you might find yourself needing to print a deposit slip for bank transactions. Unfortunately, this feature isn't directly available within QuickBooks. However, with a combination of QuickBooks' data export and a simple Microsoft Word template, you can create your own deposit slips in minutes. Let's dive into the process.

Before we start, ensure you have QuickBooks Desktop, a printer connected to your computer, and Microsoft Word installed. You'll also need a basic understanding of how to navigate QuickBooks and modify Word documents.

Exporting Data from QuickBooks

To begin, you need to export the required data from QuickBooks. QuickBooks might not directly support deposit slips, but it allows you to export data that can be used to create one.

How to Record a Bank Deposit in QuickBooks Online
How to Record a Bank Deposit in QuickBooks Online
Simple Deposit Slip Templates
Simple Deposit Slip Templates
Deposit Slip Template For Students
Deposit Slip Template For Students

Here's how to do it:

Exporting Transactions

Exporting transactions ensures you have all the necessary details for your deposit slip. In QuickBooks, go to the 'Reports' tab, then select 'Account Transaction Report'. Customize the report to display the details you need, such as the transaction date, check number, account, and amount.

the sample form for an invoicer to be used as a credit card
the sample form for an invoicer to be used as a credit card
Bank Deposit Slip Template - Free Report Templates
Bank Deposit Slip Template - Free Report Templates
Keybank Deposit Slip Template
Keybank Deposit Slip Template

Why This Step is Important

Exporting transactions allows you to have all the necessary details for your deposit slip in a format that can be easily modified and printed. If you're not sure what details to include, ask your bank. They usually provide guidelines for deposit slip layout in their business guide or website.

Creating a Word Template for Deposit Slips

With your transaction data exported, the next step is to create a Word template for your deposit slips. This template should include areas where your transaction details can be filled in.

To create the template:

QuickBooks Tip: How to Edit and Correct a Payment that is already Deposited
QuickBooks Tip: How to Edit and Correct a Payment that is already Deposited
Deposit Slips Template | Template Business
Deposit Slips Template | Template Business
Cash Deposit Slip Templates | 15+ Free Docs, Xlsx & PDF Formats, Samples, Examples, and Forms
Cash Deposit Slip Templates | 15+ Free Docs, Xlsx & PDF Formats, Samples, Examples, and Forms
Deposit slips
Deposit slips
DEPOSIT SLIP - Deposit Slip on-Demand – Print on Any Standard Letter Size White Paper.
DEPOSIT SLIP - Deposit Slip on-Demand – Print on Any Standard Letter Size White Paper.
Bank Deposit Slips Template
Bank Deposit Slips Template

Use Headers and Footers

Headers and footers are great for including consistent information, such as your business name, account number, and bank contact details. Go to the 'Insert' tab, then 'Header' or 'Footer'.

Use Merge Fields

To add dynamic data from your exported transaction details, use Word's 'Mailings' tab and 'Insert Merge Field' tool. This allows you to place fields where your transaction data will appear. You can do this by selecting ' sabotage' in the 'Data Source' field (assuming you've saved your exported data as 'sabotage.xlsx'), then clicking 'Insert Merge Field'.

Printing Deposit Slips

Now that your Word template is set up, it's time to print your deposit slips.

34 Blank Deposit Slip Templates and Examples
34 Blank Deposit Slip Templates and Examples
an invoice form is shown with two lines and numbers on the front side
an invoice form is shown with two lines and numbers on the front side
a blank receipt is shown with the word do not keep in line to print on it
a blank receipt is shown with the word do not keep in line to print on it

Here's how to do it:

Insert Your Data into the Template

First, insert your transaction data into the Word template. Go to the 'Mailings' tab, click on 'Select Recipients', then 'Use an Existing List'. Choose your exported transaction data file and click 'Open'.

Print Your Deposit Slips

Now, you can print your deposit slips. Go to the 'Mailings' tab, then 'Finish & Merge'. Choose 'Print Documents' and make sure your printer is selected. You can print as many copies as you need, adjusting the number in the 'Copies' field.

That's it! With these simple steps, you can print deposit slips using QuickBooks and a Word template. Remember, it's important to double-check the details on each slip before making a deposit. Also, keep your export template and Word template updated to reflect any changes in your business or banking details.

Managing your finances with QuickBooks just got a little easier. Happy printing!