Learn how to record debit card, credit card, and UPI payments in TallyPrime. Explore ledger creation, accounting entries, payment gateway charges, credit card expenses, and bank reconciliation with practical examples.
How to Record Debit Card, Credit Card, and UPI Payment Entries in TallyPrime
Digital payments have become a regular part of business operations. Whether you run a retail shop, wholesale business, service company, or online store, you probably receive payments through debit cards, credit cards, and UPI apps such as Google Pay, PhonePe, and Paytm.
But how should you record these transactions in TallyPrime?
Recording digital payments correctly is important for maintaining accurate accounts, tracking bank balances, reconciling transactions, and preparing financial reports. If you enter every digital payment directly into your bank account without considering transaction charges or settlement delays, your books may not match your actual bank statement.
In this guide, you will learn how to record debit card, credit card, and UPI transactions in TallyPrime with practical examples, accounting entries, and step-by-step instructions.
Understanding Digital Payment Entries in TallyPrime
Before recording transactions, it is important to understand how different payment methods work.
Although debit cards, credit cards, and UPI are all digital payment methods, their accounting treatment can be slightly different.
Payment Method | How It Works | Accounting Treatment |
|---|---|---|
Debit Card | Money is deducted from the customer's bank account | Bank or payment clearing account |
Credit Card | Payment is processed through a credit card network | Bank or payment clearing account |
UPI | Money is transferred through UPI | Bank account or UPI clearing account |
UPI with Payment Gateway | Amount is received after settlement | Payment gateway clearing account |
Important: If the payment reaches your bank account immediately, you can record it directly in the bank ledger. If the payment processor settles the money later or deducts transaction charges, using a separate clearing ledger makes accounting easier.
Creating Ledgers for Digital Payments in TallyPrime
Before entering transactions, create the necessary ledgers in TallyPrime.
For better accounting management, you should maintain separate ledgers for different payment methods.
Here are the recommended ledgers:
Ledger Name | Under Group |
|---|---|
HDFC Bank Account | Bank Accounts |
SBI Bank Account | Bank Accounts |
UPI Clearing Account | Current Assets |
Debit Card Clearing | Current Assets |
Credit Card Clearing | Current Assets |
Payment Gateway Charges | Indirect Expenses |
Sales Account | Sales Accounts |
Purchase Account | Purchase Accounts |
You do not necessarily need separate clearing accounts for every payment method. You can also maintain a single payment clearing ledger if your transaction volume is low.
How to Create a Ledger in TallyPrime
Follow these steps:
Open TallyPrime.
Select the required company.
Go to Gateway of Tally.
Select Create.
Choose Ledger.
Enter the ledger name, such as UPI Clearing Account.
Select the appropriate group.
Save the ledger.
Repeat these steps to create the other required ledgers.
How to Record Debit Card Payment Entries in TallyPrime
When a customer pays your business using a debit card, the amount is generally deducted from the customer's bank account and transferred to your merchant bank account.
For example:
Suppose you sell goods worth ₹10,000 to a customer. The customer pays the full amount using a debit card.
Assume the payment is received directly into your bank account.
Accounting Entry:
Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
Bank Account Dr. | 10,000 | – |
To Sales Account | – | 10,000 |
Total | 10,000 | 10,000 |
Steps to Enter Debit Card Sales in TallyPrime
Open Gateway of Tally.
Select Vouchers.
Press F8 (Sales).
Enter the sales voucher date.
Select the customer ledger or Cash/Bank Party ledger as applicable.
Select the sales ledger.
Enter the sales amount.
Select the appropriate bank ledger as the payment account, if using an immediate receipt entry.
Enter the narration: Payment received through debit card.
Save the voucher.
Practical Tip: If you use a separate sales invoice followed by a payment receipt, record the sale first and then record the bank receipt against the customer's outstanding balance. This avoids recording the same income twice.
Debit Card Payment with Bank Charges
Suppose a customer pays ₹10,000 through a debit card, but the payment processor deducts ₹100 as transaction charges.
Your bank receives only ₹9,900.
The accounting entry will be:
Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
Bank Account Dr. | 9,900 | – |
Payment Gateway Charges Dr. | 100 | – |
To UPI/Card Clearing Account | – | 10,000 |
Total | 10,000 | 10,000 |
This entry assumes the original sale has already been recorded and the clearing account holds the payment due from the processor.
How to Record Credit Card Payment Entries in TallyPrime
Credit card payments are commonly used by customers for purchasing goods and services.
From the seller's accounting perspective, the payment is generally treated similarly to a debit card transaction. However, the amount may reach the merchant's bank account after a settlement period.
For example:
A customer purchases products worth ₹15,000 and pays through a credit card. The payment gateway deducts ₹150 as processing charges and transfers ₹14,850 to your bank account.
Accounting Entry:
Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
Bank Account Dr. | 14,850 | – |
Credit Card Processing Charges Dr. | 150 | – |
To Credit Card Clearing Account | – | 15,000 |
Total | 15,000 | 15,000 |
Steps to Record Credit Card Payments
Open TallyPrime.
Go to Gateway of Tally.
Select Vouchers.
Press F6 (Receipt).
Enter the transaction date.
Select the Credit Card Clearing Account.
Enter the amount received.
Select the appropriate bank account.
Enter the narration.
Save the voucher.
Practical Tip: Do not record the full credit card payment as a direct bank receipt if the amount has not yet reached your bank. Use a clearing account to track pending settlements.
How to Record UPI Payments in TallyPrime
UPI payments are widely used by Indian businesses because customers can transfer money instantly using mobile applications.
Popular UPI payment applications include:
Google Pay
PhonePe
Paytm
BHIM UPI
Bank UPI applications
If a customer pays ₹5,000 through UPI and the amount is credited directly to your bank account, you can record the transaction as follows.
Accounting Entry:
Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
Bank Account Dr. | 5,000 | – |
To Sales Account | – | 5,000 |
Total | 5,000 | 5,000 |
Steps to Record UPI Sales in TallyPrime
Open your company in TallyPrime.
Go to Vouchers.
Press F8 (Sales).
Select the customer or appropriate party ledger.
Choose the sales ledger.
Enter the invoice amount.
Record the payment through the relevant bank ledger or use a separate receipt voucher.
Add the narration: Received through UPI.
Save the transaction.
UPI Payment Through a QR Code
Many shops accept payments through QR codes displayed at the billing counter.
For example:
Total bill: ₹2,500
Customer pays through PhonePe QR code.
Amount credited to your bank: ₹2,500.
If the money is credited directly to your bank, record:
Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
Bank Account Dr. | 2,500 | – |
To Sales Account | – | 2,500 |
In the narration, mention the UPI payment reference or UTR number to make future verification easier.
How to Record UPI Payments Received Through PhonePe or Paytm Settlement
Sometimes, businesses receive payments through a merchant payment service that collects money first and transfers it to the bank later.
For example:
Customer payment: ₹20,000
Payment processing charges: ₹100
Amount received in bank: ₹19,900
First, record the payment received from customers:
Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
Payment Gateway Clearing Dr. | 20,000 | – |
To Sales Account | – | 20,000 |
Next, record the settlement:
Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
Bank Account Dr. | 19,900 | – |
Payment Gateway Charges Dr. | 100 | – |
To Payment Gateway Clearing | – | 20,000 |
Total | 20,000 | 20,000 |
This approach helps you identify pending settlements and payment deductions.
How to Record Business Expenses Paid Through Debit Card, Credit Card, or UPI
Digital payments are not limited to sales. Businesses also use cards and UPI to pay suppliers, purchase office supplies, pay electricity bills, and manage other expenses.
Let's understand this with an example.
Suppose you purchase office supplies worth ₹3,000 and pay using UPI directly from your business bank account.
Accounting Entry:
Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
Office Expenses Dr. | 3,000 | – |
To Bank Account | – | 3,000 |
Total | 3,000 | 3,000 |
Steps to Record Digital Payment Expenses
Open TallyPrime.
Go to Vouchers.
Press F5 (Payment).
Select the relevant expense ledger.
Enter the amount.
Select the bank account from which the payment was made.
Add the payment method in the narration.
Save the voucher.
You can use the same process for debit card and UPI expenses when the payment is made directly from your bank account.
How to Record Credit Card Expenses in TallyPrime
Credit card expenses require slightly different treatment because the money is not immediately deducted from your bank account. Instead, you receive a liability that must be paid to the credit card company later.
For example:
Your business purchases a laptop worth ₹50,000 using a business credit card.
Create a ledger named Business Credit Card Payable under the appropriate liability group.
Purchase Entry:
Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
Computer Equipment Dr. | 50,000 | – |
To Business Credit Card Payable | – | 50,000 |
Total | 50,000 | 50,000 |
When you pay the credit card bill from your bank account, record:
Particulars | Debit (₹) | Credit (₹) |
|---|---|---|
Business Credit Card Payable Dr. | 50,000 | – |
To Bank Account | – | 50,000 |
Total | 50,000 | 50,000 |
This ensures that your credit card outstanding balance is properly tracked.
Important: If the purchase includes GST and you are eligible to claim Input Tax Credit, record the applicable expense or asset value and input GST separately based on the supplier's tax invoice and applicable GST rules.
Debit Card vs Credit Card vs UPI: Accounting Entry Comparison
The following table summarises how different digital payment transactions are recorded in TallyPrime.
Transaction | Debit Ledger | Credit Ledger |
|---|---|---|
Debit card sale received directly | Bank Account | Sales Account |
Credit card sale pending settlement | Credit Card Clearing | Sales Account |
UPI sale received directly | Bank Account | Sales Account |
UPI payment through gateway | Gateway Clearing | Sales Account |
Business expense paid through UPI | Expense Account | Bank Account |
Business expense paid through credit card | Expense Account | Credit Card Payable |
Credit card bill payment | Credit Card Payable | Bank Account |
Payment gateway settlement | Bank + Charges | Gateway Clearing |
Common Mistakes to Avoid When Recording Digital Payments
Even a small accounting mistake can create differences between your TallyPrime books and bank statement.
Here are some common mistakes to watch out for.
Recording the Same Sale Twice
If you have already recorded a sales invoice, do not create another sales voucher when the customer pays. Record only the receipt against the existing outstanding invoice.
Ignoring Payment Gateway Charges
Payment processors may deduct transaction charges before transferring money to your bank. Record these charges separately instead of treating the net settlement as the full sales amount.
Using the Wrong Bank Ledger
Always select the bank account from which the payment was actually made or into which the money was received.
Not Tracking Pending Settlements
If a payment processor has collected money but has not yet transferred it to your bank, keep the amount in a clearing account until settlement.
Recording Personal Expenses as Business Expenses
If you use a personal credit card for business purchases, record the business expense separately and show the amount payable to the cardholder or owner. Do not automatically classify the entire personal credit card bill as a business expense.
How to Reconcile Debit Card, Credit Card, and UPI Transactions in TallyPrime
Bank reconciliation helps ensure that the transactions recorded in TallyPrime match your actual bank statement.
Follow these steps:
Open Gateway of Tally.
Go to Banking.
Select Bank Reconciliation.
Choose the relevant bank account.
Compare the transactions with your bank statement.
Enter the appropriate bank dates where required.
Identify missing transactions, duplicate entries, and settlement differences.
Save the reconciliation details.
You should ideally reconcile your digital payments regularly, especially when your business receives a large number of UPI and card transactions.
Best Practices for Managing Digital Payments in TallyPrime
For smooth accounting, follow these practical tips:
Maintain separate ledgers for major payment channels.
Record UPI reference numbers and transaction IDs in the narration.
Reconcile bank transactions regularly.
Record payment gateway charges separately.
Track pending card and UPI settlements.
Avoid duplicate sales and receipt entries.
Keep business and personal transactions separate.
Verify credit card outstanding balances every month.
Maintain supporting invoices and payment receipts.
These practices can save time during GST reconciliation, financial reporting, and account auditing.
Frequently Asked Questions (FAQs)
Q1. Can I record UPI payments directly in TallyPrime?
Yes. You can record UPI payments directly through a bank ledger when the money is credited to your bank account.
Q2. Which voucher is used for debit card payments in TallyPrime?
Use a Receipt voucher for receiving payments against existing invoices or a Sales voucher with the appropriate payment details when recording an immediate cash or bank sale.
Q3. How do I record credit card expenses in TallyPrime?
Create a credit card payable ledger and record the expense or purchase against that liability. When you pay the bill, debit the liability and credit your bank account.
Q4. How do I record PhonePe and Google Pay transactions?
Record them through your bank ledger if the money is received directly. Otherwise, use a separate UPI or payment gateway clearing ledger.
Q5. Can I record payment gateway charges separately in TallyPrime?
Yes. Create a Payment Gateway Charges ledger under Indirect Expenses and record the charges separately during settlement.
Conclusion
Recording debit card, credit card, and UPI transactions correctly in TallyPrime helps maintain accurate business accounts and makes bank reconciliation much easier.
For payments received directly into your bank account, you can use the bank ledger. For payments involving delayed settlements or processing charges, a separate clearing ledger is generally a better option.
Similarly, credit card purchases should be recorded as liabilities until the outstanding amount is paid.
Once you understand these basic accounting treatments, managing digital payments in TallyPrime becomes much easier, whether you operate a small retail shop or a growing business.
COMMENTS