How to Upload Checks for Printing in QuickBooks Online Using SaasAnt

Saasant is a powerful data import tool that integrates with QuickBooks Online.

It allows you to upload bulk transactions, including checks, bills, invoices, and more.

This tool is especially useful when you need to import a large number of checks from a spreadsheet rather than manually entering them into QBO.

In this post, I’ll guide you through using Saasant to upload checks and prepare them for printing in QBO, saving you time and effort.

Quick Instructions:

  1. Download Saasant’s exclusive template
  2. Add your checks to the template
  3. Change Print Status to TRUE
  4. In Saasant, click New Import in the left side menu
  5. Click Checks
  6. Upload your edited template file
  7. In the Select Sheet drop-down, select Checks.
  8. Double-check mapping
  9. Click the Review button
  10. Review the list of checks
  11. Click the Upload button
  12. Log into QBO
  13. Click the +New button in the upper left corner
  14. Click Print checks in the Vendors column
  15. Enter a Starting check number
  16. Click the Preview and print button

Keep reading for a complete walkthrough with screenshots:

Download the Exclusive Template From Saasant

To begin, log into Saasant.

On the right-hand menu, click New import. Select any type of transaction, and under Use our templates, download the Exclusive template.

To mark checks as printable download Saasant's exclusive template

You need the Exclusive template as the Simple template does not allow marking checks as printable.

Add Checks to the Template

In the Saasant template, look for the tab labeled Checks across the bottom.

Make sure you delete the sample data, then fill in as much or as little as you need. 

To print your checks, scroll to the last column, Print Status. Make sure every check you want to print has a TRUE status.

Saasant exclusive template filled out to print checks in QBO

Note: If you’re printing the checks, do NOT fill in the Check no column.

Import Checks

Once your template is ready, click New Import in the left side menu.

Click on Checks in the Vendor Transaction section.

New import of Checks using Saasant

Drag ‘n’ drop or browse to your file.

Upload files for importing checks into QBO using Saasant

This will take you to step 2, Map Fields.

In the Select Sheet drop-down, select Checks.

Scroll through and check that everything’s mapped correctly. 

When you’re ready, click the blue Review button.

Mapping fields for importing checks into QBO using Saasant

Step 3 is the Review. It lists all the checks you’re importing so you can do a final review to ensure everything is correct. When ready, click Upload.

Review before uploading checks into QBO using Saasant

It will take a few moments for the import to process.

Once it’s finished, Saasant will show you if there are any errors.

Success message when importing checks into QBO with Saasant

If you have any errors, click the Show Results button to see a list of transactions with the errors highlighted.

Viewing results after importing checks into QBO with Saasant

Imported Checks in QuickBooks

When I view my imported check in QuickBooks, everything imported correctly, and Print later is checked.

Check imported into QBO with Print later checked

Print Checks

To print your imported checks, click the +New button in the upper left corner of QBO.

In the Vendors column, click Print checks.

Print checks from the +New button in QBO

Enter a Starting check number.

Select the checks you want to print. Double-check that you have checks in your printer.

Click the Preview and print button.

Printing checks with QBO

Final Thoughts

Using Saasant to upload checks into QuickBooks Online is a great way to save time and reduce errors when dealing with bulk transactions.

Instead of manually entering each check, you can quickly upload them using a simple spreadsheet, making the process more efficient.

Scroll down if you’d like to watch a video walk-through of this process.

☕ If you found this helpful, you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

If you have questions about using Saasant or printing checks with QuickBooks Online, click the green button below to schedule a free consultation.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

How to Manage Incorrect Payee and Category Suggestions in QuickBooks Online with Bank Rules

Learn how to use bank rules to make sure you don't incorrectly categorize transactions.

Testing SupaClerk Bank Statement Conversion to CSV for QuickBooks Online Import

Learn how to convert a PDF bank statement into a CSV and then import it into QuickBooks Online.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.