How to Print Cheques in Excel: Free Method + a Faster Way

Most accountants already keep their payments in Microsoft Excel, so printing cheques from Excel feels natural. You can build a simple cheque format in Excel yourself, or use a ready Excel-based cheque printing software that does the setup, amount in words and record keeping for you. I’ve done both, so let me walk you through each one. In fact, MoneyFlex started as a cheque format I built in Excel for my own accounts work and used for years before turning it into software.

Method 1: Make Your Own Cheque Format in Excel (Free)

This method costs nothing, but it needs some Excel skill and patience. Follow these steps.

Step 1: Measure the cheque

Measure your cheque leaf with a ruler. Also note where the date boxes, Pay line, amount in words line and ₹ box start, measured from the top-left corner of the cheque.

Step 2: Set the page size

In Excel, go to Page Layout > Size. Many printers let you create a custom paper size equal to your cheque from the printer properties. Set all margins to zero or the minimum your printer allows.

Step 3: Build the layout with cells

Switch to View > Page Layout so you can see rulers in centimetres. Adjust row heights and column widths so that one cell sits on the date line, one on the Pay line, one on the amount in words line and one on the amount box. Merge cells where a field is long, like the payee name.

Step 4: Link the cells to your data

Keep your payment details (date, party name, amount) on a second sheet. In the cheque sheet, link each field with a simple formula, for example =Data!B2 for the payee name. Format the date cell as ddmmyyyy and add letter spacing to match the date boxes.

Step 5: Convert the amount into words

Excel has no built-in function to write an amount in words in the Indian lakh and crore system. You will need a VBA macro (often called SpellNumber, changed for lakh and crore) or a long formula. Test it on many amounts, because one wrong word makes the cheque useless. You can check your result with our free amount in words converter.

Step 6: Test print and adjust

Print on plain paper, place it on a real cheque and hold both against light. Change row heights or column widths until every field sits in the right place. Our guide on cheque printing alignment will help if the print keeps moving.

Drawbacks of the DIY Excel Method

  • Setting up takes hours, and every bank needs its own layout.
  • Row heights and fonts can change when the file is opened on another computer.
  • Printing many cheques together needs extra macros.
  • There is no automatic cheque register or payment report unless you build it.

Method 2: The Faster Way – Excel-Based Cheque Printing Software

If you want the comfort of Excel without building everything yourself, use MoneyFlex. It is an Excel-based cheque printing software made by an accountant who printed his company’s cheques from Excel for years. It runs inside Microsoft Excel on Windows and Mac, so there is no heavy installation.

What MoneyFlex does for you

  • Any bank cheque: Move the date, name, amount and A/c Payee fields to match your cheque leaf and save the setting.
  • Amount in words: Written automatically in lakh and crore with “Only” at the end.
  • Bulk printing: Enter many payments in the list and print the cheques in one go. See how bulk cheque printing works.
  • Cheque issued list: Every cheque is saved with date, party name, amount, cheque number and purpose of payment.
  • Reports: Party-wise and month-wise totals of the cheques you have issued.
  • Post-dated cheques: See how many days are left before a post-dated cheque becomes due.
  • Your own style: Change the font name, size and colour, and add text like “Not Above” or “RTGS/NEFT”.

Print cheques from Excel without building anything

Try MoneyFlex free for 3 days. Set up your bank once, then print single or bulk cheques straight from Excel with amount in words and a full cheque register.

Download Free Trial (3 Days)

DIY Excel vs MoneyFlex: Which One Should You Use?

If you print only one or two cheques a month and enjoy working with Excel formulas and VBA, the free method is a good learning project. If you print cheques every week, handle more than one bank or need records for audit, an Excel-based software saves hours every month and removes the risk of a wrong amount in words.

Frequently Asked Questions

Can I print a cheque directly from Excel?

Yes. You can print a cheque from Excel by placing the payee name, date and amount in cells that match the cheque leaf, or by using an Excel-based cheque printing software like MoneyFlex.

Is there a formula in Excel for amount in words in rupees?

Not a built-in one. You need a VBA macro or a long custom formula for lakh and crore. MoneyFlex already includes this.

Does Excel cheque printing work on Mac?

MoneyFlex works with Microsoft Excel on both Windows and Mac.

Which printer do I need to print cheques from Excel?

Any standard inkjet or laser printer that can feed a cheque leaf. Read our guide on the best printer for cheque printing.

So, Which Way Should You Go?

You can print cheques in Excel for free if you have the time to build and test your own format. For daily use, an Excel-based cheque printing software gives you the same Excel comfort with ready field setup, automatic amount in words, bulk printing and a complete cheque register. Also read: how to print a cheque from your printer.

Leave a Comment