---
title: "How do I import and reconcile credit card transactions in BUSY?"
description: "How do I import and reconcile credit card transactions in BUSY?"
canonical: "https://busy.in/faqs/how-do-i-import-and-reconcile-credit-card-transactions-in-busy-answerid-55998/"
---

# How do I import and reconcile credit card transactions in BUSY?

To import your bank statement data in BUSY through the process of excel and here are the steps :

Step 1: Prepare Excel data as per BUSY invoice structure
Step 2: Go to Administration Menu
Step 3: Click on Data export import option
Step 4: Then click on Import voucher from excel option
Step 5: Then select voucher type and format in which you are add field according to their excel
Step 6: Then attach excel file in the respective field
Step 7: Then specify sheet no., row no., then click on OK button
Step 8: Then start importing voucher from excel
Step 9: After copleting the process, a confirmation message will appear on the window

To Reconcile bank data in BUSY :
Step 10: Go to Administration Menu
Step 11: Click on configuration
Step 12: Then click on Feature and option
Step 13: Then click on Accounts feature
Step 14: Then tick on the Bank Reconcilation option and save the configuration
Step 15: Then go to display menu
Step 16: Click on Bank Reconcilation
Step 17: then click on Show uncleared entries option
Step 18: Then select bank name and specify starting date and ending date then click on OK button
Step 19: Then you can review the list of all bank entries, you can reconcile by pressing F4. Specify the clear date, enable Clear Full Voucher as Y, and then save the changes.

## Related FAQs

- [How can I import data from Excel without encountering errors in BUSY?](https://busy.in/faqs/how-can-i-import-data-from-excel-without-encountering-errors-in-busy-answerid-52147/)
- [i Want to Upload Accouting data from Excel to BUSY Software](https://busy.in/faqs/i-want-to-upload-accouting-data-from-excel-to-busy-software-answerid-55946/)
- [How to import data in BUSY from other software and export data from BUSY?](https://busy.in/faqs/how-to-import-data-in-busy-from-other-software-and-export-data-from-busy-answerid-44958/)
- [I started using BUSY after a certain date but sales before that date are not reflected. How can I enter opening sales values or previous sales data into BUSY?](https://busy.in/faqs/started-using-after-certain-but-before-date-reflected-enter-opening-values-or-previous-sales-data-into-busy-answerid-25687/)
- [I gave some handwritten bills before using BUSY. How can I account for these old bills and entries in BUSY now?](https://busy.in/faqs/gave-some-handwritten-before-using-account-these-old-bills-entries-busy-now-answerid-29894/)