GSTR-2B reconciliation with TallyPrime

“This is not a JSON file. On the GST portal, choose Download, then JSON. Upload that file here.”

Where you see it: Accounts > GSTR-2B Reconciliation, Upload file step, in the red box This file could not be read.

The file is not JSON. Often the Excel file was chosen on the portal. Or the .zip file was uploaded without extracting it. Nothing was read or saved in TallyPrime.

1. 1

   On the GST portal, open the Returns Dashboard and choose the financial year and month.

2. 2

   Under GSTR-2B choose View, then Download and the JSON option (not Excel).

3. 3

   If the download is a .zip file, right-click it, choose Extract All, and use the .json file inside.

4. 4

   Upload the .json file here.

It worked when: The page moves on to Check against TallyPrime.

Next time: See how to download the GSTR-2B JSON.

“Only on portal”

Where you see it: Accounts > GSTR-2B Reconciliation, Check against TallyPrime step, the Only on portal tab and tile.

No purchase or note in TallyPrime has this supplier's GSTIN and bill number. The bill may not be entered. Or its supplier ledger has a different GSTIN. Or it has another number. Nothing is saved in TallyPrime yet.

1. 1

   Look for the bill in TallyPrime by supplier and amount.

2. 2

   If it is there, check three things: the supplier ledger's GSTIN, that the ledger is under Sundry Creditors, and the supplier invoice number. Correct what is wrong, then choose Check again.

3. 3

   If it is really missing, tick it and choose Continue to save, or enter it by hand.

4. 4

   Do not save a bill that is already entered. Correct its GSTIN or number instead. Otherwise it is in your books twice.

It worked when: After you correct or save it, Check again shows it under Matched.

“Not in this GSTR-2B yet: the supplier may not have filed it.”

Where you see it: Accounts > GSTR-2B Reconciliation, Only in books tab.

A bill or note from a registered supplier is in TallyPrime for this month. But it is not in this GSTR-2B. You get input tax credit on it only once it shows in a GSTR-2B. Nothing was changed in TallyPrime.

1. 1

   Check the supplier's GSTIN and bill number in TallyPrime for typing mistakes. A mistake there also puts the portal copy under Only on portal.

2. 2

   If they are right, ask the supplier to report the bill in their GSTR-1.

3. 3

   A bill the supplier reports late shows in a later month's GSTR-2B. Check that month's file when it comes.

Next time: Download the CSV of this tab. Share it with suppliers who have not filed.

“Total differs by ₹1,180.00: ₹11,800.00 in TallyPrime, ₹10,620.00 on the portal.”

Where you see it: Accounts > GSTR-2B Reconciliation, Mismatch tab, What differs column.

The bill was found by supplier GSTIN and number. But its total differs by more than ₹1 from what the supplier reported. Nothing was changed in TallyPrime.

1. 1

   Compare the bill in TallyPrime with the supplier's invoice.

2. 2

   If TallyPrime is wrong, open the purchase voucher in TallyPrime and correct it.

3. 3

   If the supplier reported it wrongly, ask them to amend it in their GSTR-1.

4. 4

   Choose Check again.

It worked when: The row moves to Matched.

“Date differs: 05 Sep 2026 in TallyPrime, 03 Sep 2026 on the portal.”

Where you see it: Accounts > GSTR-2B Reconciliation, Mismatch tab, What differs column.

The bill was found. But its date in TallyPrime is not the invoice date the supplier reported. If you date purchases on the day the bill arrives, this is normal. Your credit does not change. Nothing was changed in TallyPrime.

1. 1

   Open the purchase voucher in TallyPrime and compare its date with the date on the supplier's bill.

2. 2

   If the date is wrong by mistake, correct it in TallyPrime.

3. 3

   If you used the day the bill arrived on purpose, change nothing.

4. 4

   If the supplier reported the wrong date, ask them to amend it in their GSTR-1.

5. 5

   Choose Check again after any correction.

It worked when: The row moves to Matched once the dates agree.

“Bill number differs: INV-1045 in TallyPrime, INV/1054 on the portal.”

Where you see it: Accounts > GSTR-2B Reconciliation, Mismatch tab, with Not the same bill or the Bill in TallyPrime list.

No bill has the portal's number. But a bill with another number has the same supplier and total, on a close date. It is likely the same bill, entered with a different number. Nothing was changed in TallyPrime. A likely match is never saved on its own.

1. 1

   If it is the same bill, change the supplier invoice number in TallyPrime to the portal's. Then choose Check again.

2. 2

   If several bills fit, choose the right one under Bill in TallyPrime.

3. 3

   If it is a different bill, choose Not the same bill (or None of these). It moves to Only on portal, ready to save.

It worked when: The row moves to Matched after checking again.

““Sharma Traders” has no GSTIN in TallyPrime. Add 27AABCS1234F1Z5 to that ledger.”

Where you see it: Accounts > GSTR-2B Reconciliation, Mismatch tab, What differs column.

A bill with this number and amount is in TallyPrime. But its supplier ledger has no GSTIN. Bills are matched by GSTIN, so this one cannot be matched. Only suppliers under Sundry Creditors are matched. Nothing was changed in TallyPrime.

1. 1

   In TallyPrime, go to Gateway of Tally > Alter > Ledger and open the supplier ledger.

2. 2

   Set the registration type to Regular. Enter the GSTIN shown in the message.

3. 3

   If the ledger has the GSTIN, check it is under Sundry Creditors. If not, move it there.

4. 4

   Save the ledger.

5. 5

   Choose Check again in Balancely.

It worked when: The row moves to Matched.

Next time: Keep every registered supplier's GSTIN on their ledger under Sundry Creditors.

“TallyPrime could not be read”

Where you see it: Accounts > GSTR-2B Reconciliation, Check against TallyPrime step, in place of the results, with Try again.

Balancely could not get your purchases from TallyPrime. The text under the title gives the reason. Nothing was saved.

1. 1

   Make sure the computer with TallyPrime is on, the connector is running and TallyPrime has this company open.

2. 2

   Close any message box open in TallyPrime.

3. 3

   If it says too many reads, wait a minute and close other Balancely tabs that are reading reports.

4. 4

   Choose Try again.

It worked when: The tabs and tiles appear.

Next time: See Connector and TallyPrime for each connector message.

“Choose a purchase ledger for 18% within your state.”

Where you see it: Accounts > GSTR-2B Reconciliation, Save what is missing step, the status of each row. Rows that need a choice are not saved.

Balancely needs to know which ledgers to use. Then it can save the bill in TallyPrime. This is normal in the first month for each company. Nothing is saved until the row shows Ready.

1. 1

   Under Ledgers to use, choose a purchase ledger for each rate. Choose one for your state and one for other states.

2. 2

   Choose your CGST, SGST, IGST and cess ledgers. They must already be in TallyPrime.

3. 3

   For reverse charge bills, choose their own purchase ledger. Choose the reverse charge tax ledgers too.

4. 4

   If a row rounds, choose a Round-off ledger.

5. 5

   Under Suppliers, choose Use a ledger in TallyPrime and choose the ledger. Or choose Add as a new supplier.

6. 6

   When the rows show Ready, choose Save.

It worked when: Every row you want shows Ready.

Next time: Balancely keeps your choices for the company and your whole team. Next month needs far fewer.

“This is not a GSTR-2B file. Download the JSON from the GST portal: Returns, GSTR-2B, Download (JSON).”

Where you see it: Accounts > GSTR-2B Reconciliation, Upload file step, in the red box This file could not be read.

The file is JSON, but for another return, such as GSTR-2A, GSTR-1 or GSTR-3B. This page reads only GSTR-2B. Nothing was read or saved.

1. 1

   On the GST portal, download the GSTR-2B JSON for the month. GSTR-2A is a different file.

2. 2

   Upload it here.

3. 3

   If the file is a GSTR-1, upload it on Accounts > GSTR-1 Reconciliation instead.

It worked when: The page moves on to Check against TallyPrime.

“The GSTR-2B for Sep 2026 has no invoices in it.”

Where you see it: Accounts > GSTR-2B Reconciliation, Upload file step, in the red box This file could not be read.

No supplier reported a bill or note to you for this month. Or the file was edited or cut short, so its month is missing. Nothing was read or saved.

1. 1

   Check that you downloaded the right month and GSTIN on the portal.

2. 2

   Download the JSON again and upload it without opening or editing it.

3. 3

   If the month really has no bills, there is nothing to check.

“This file is for another GSTIN”

Where you see it: Accounts > GSTR-2B Reconciliation, Check against TallyPrime step, red box above the results. Continue to save stays greyed out.

The GSTIN in the file is not the one TallyPrime has for the company chosen at the top. Nothing was saved.

1. 1

   Choose the right company under Company at the top. The check starts again for it.

2. 2

   Tick This file belongs to only if the company's GSTIN in TallyPrime is old, or it really has this registration too.

3. 3

   Better still, correct the GSTIN in the company's GST details in TallyPrime. Then the next check matches.

It worked when: The red box goes away, or turns amber once ticked, and Continue to save can be chosen.

“Entered 2 times in TallyPrime.”

Where you see it: Accounts > GSTR-2B Reconciliation, Mismatch tab, What differs column.

More than one purchase in TallyPrime has this supplier's GSTIN and bill number. The bill may be entered twice, and its input tax credit counted twice. Nothing was changed in TallyPrime.

1. 1

   Open the supplier's ledger in TallyPrime and find the entries with this bill number.

2. 2

   If one is a copy, cancel or delete it.

3. 3

   If they are different bills, correct the supplier invoice number on the wrong one.

4. 4

   Choose Check again.

It worked when: The row moves to Matched.

“ITC not available (place of supply rule). Enter it in TallyPrime by hand if you still need it.”

Where you see it: Accounts > GSTR-2B Reconciliation, Skipped tab, Why skipped column.

The portal says input tax credit on this bill is not available to you. So it is not saved from here. Nothing is saved in TallyPrime from this tab.

1. 1

   Check the bill with your CA. Ask if it is a real expense and why credit is not available.

2. 2

   If you still need it in your books, enter it by hand in TallyPrime. Do not claim input tax credit on it.

3. 3

   Leave it out of the input tax credit you claim in GSTR-3B.

“Amends invoice INV/1054 already reported. Correct that bill in TallyPrime instead.”

Where you see it: Accounts > GSTR-2B Reconciliation, Skipped tab, Why skipped column.

The supplier changed a bill from an earlier month. Saving it here would add a second bill. Nothing is saved in TallyPrime from this tab.

1. 1

   Find the first bill in TallyPrime.

2. 2

   Change it to the new values shown on the portal.

3. 3

   If the first bill was never entered, enter it by hand with the new values.

“Credit passed on by your head office (ISD). Record it with a journal.”

Where you see it: Accounts > GSTR-2B Reconciliation, Skipped tab, Why skipped column.

These need details the GSTR-2B does not have, such as the bill of entry. So they are only listed. Nothing is saved in TallyPrime from this tab.

1. 1

   For ISD credit, enter a journal in TallyPrime that moves the credit to your input tax ledgers. Ask your CA how.

2. 2

   For imports, enter the purchase from the bill of entry. Add the customs duty and IGST paid.

3. 3

   For reverse charge notes, adjust your reverse charge entries by hand.

““Input IGST” is chosen for both the input credit and the tax payable. Use a separate reverse charge ledger.”

Where you see it: Accounts > GSTR-2B Reconciliation, Save what is missing step, a reverse charge row marked Needs a choice.

A reverse charge bill has two tax lines: input credit, and the tax you must pay. They need different ledgers. With one ledger, the two cancel out. Nothing was saved.

1. 1

   In TallyPrime, create a ledger under Duties & Taxes for the tax you pay, for example Output IGST (RCM) payable. Set the right type of duty.

2. 2

   Under Ledgers to use, choose it as the reverse charge tax ledger.

3. 3

   Keep your input ledger for the input credit.

It worked when: The row shows Ready.

“TallyPrime did not say it was saved. Look for it in TallyPrime. We will not add it again.”

Where you see it: Accounts > GSTR-2B Reconciliation, the note on an Only on portal row, and under the row on Save what is missing.

This bill was saved from here before. It may still be saving. Or TallyPrime's answer was lost, so it is held back. Or it was saved but is no longer in TallyPrime, so it would be saved again. TallyPrime may already have the bill. You cannot tick held-back rows.

1. 1

   For on its way, wait for it to finish. Then choose Check again.

2. 2

   For did not confirm, look for the bill in the Day Book in TallyPrime. If it is there, choose Check again.

3. 3

   If it is not there, open it in Accounts > Activity History, choose view import, then Save failed entries again. It cannot be saved twice.

4. 4

   For no longer has it, it is saved again on purpose. If you deleted the bill on purpose, untick it.

It worked when: The row shows under Matched after checking again.

Next time: Do not use Fix & retry in Activity History for these bills. Save them again from the import.

“The bills could not be saved in TallyPrime”

Where you see it: Accounts > GSTR-2B Reconciliation, Save what is missing step, red box above the Save button.

TallyPrime did not take a new supplier, or the whole save stopped. Up to 500 entries means you ticked more than 500 entries. Each reverse charge bill counts as two: the bill and its tax journal. Suppliers added before this stay in TallyPrime. No bills were saved this time.

1. 1

   For up to 500 entries, untick some rows, such as the reverse charge ones. Save in two rounds.

2. 2

   If a supplier already exists and it is the same supplier, under Suppliers choose Use a ledger in TallyPrime and choose the ledger.

3. 3

   If it is a different party with the same name, enter another name under Add as a new supplier.

4. 4

   For connector or plan messages, see Connector and TallyPrime or Plans and billing.

5. 5

   Choose Save again. Nothing is saved twice.

It worked when: The progress card Saving bills and notes from appears.

“Start with your GSTR-2B”

Where you see it: Accounts > GSTR-2B Reconciliation, the Save what is missing step, after the page was reloaded.

Only the open page keeps the file. If you reload or open the page again, it is gone. Nothing was lost. Bills already saved stay in TallyPrime and are not saved twice.

1. 1

   Choose Upload file.

2. 2

   Upload the same GSTR-2B JSON again. The check starts on its own.

3. 3

   Continue to save as before.

“The invoice value ₹11,800.00 is ₹100.00 away from taxable value plus tax (₹11,700.00). Check this invoice with the supplier.”

Where you see it: Accounts > GSTR-2B Reconciliation, Save what is missing step, a row marked Needs a choice.

No choice can fix this. The supplier's figures do not add up, or a value is missing in the file. This row is never saved from here.

1. 1

   Get the bill from the supplier.

2. 2

   Enter it by hand in TallyPrime from the bill.

3. 3

   If the supplier reported it wrongly, ask them to amend it in their GSTR-1.

“Entered as a purchase in TallyPrime. TallyPrime’s own returns expect a supplier’s debit note as a Credit Note.”

Where you see it: Accounts > GSTR-2B Reconciliation, Mismatch tab, What differs column.

The supplier sent a debit note to charge you more. It is entered in TallyPrime as a Purchase. But TallyPrime's GST returns read a supplier's debit note from a Credit Note voucher. Nothing was changed in TallyPrime.

1. 1

   Ask your CA whether to keep it as it is.

2. 2

   To match TallyPrime's returns, enter the debit note as a Credit Note voucher. Then cancel the purchase entry.

3. 3

   Choose Check again.