GST Sales Export for TallyPrime for OpenCart 2.3, 3.x and 4.x — GST sales vouchers

GST Sales Export for TallyPrime moves the sales of an Indian OpenCart store into TallyPrime: sales vouchers with CGST and SGST or IGST by place of supply, and customer ledgers with GSTIN. Pick a period and order statuses, download two XML files (ledgers and vouchers) and import them in TallyPrime with Alt+O. One module for OpenCart 4.x, 3.x and 2.3.

What the buyer sees

Nothing changes for the buyer: the order is placed as usual. When a business buyer gives a GSTIN in a checkout field (custom field) or in the company details, the module finds it and books the sale as B2B with the GSTIN on the customer ledger; the rest go as B2C with the registration type Unregistered/Consumer.

What the admin gets

The order page gets a TallyPrime panel: the voucher, its number, amount and state, and below it the Dr/Cr lines — customer, Sales, shipping, CGST and SGST or IGST — with the place of supply and why that tax applies. From there you download the file of this order, and in Pro send it to TallyPrime, make a credit note or cancel the voucher.

The export page (also in the Sales menu): period, order statuses and “only orders not exported yet”. “Make files” gives a ledgers file (customers, Sales, Shipping Charges, Discount Allowed, Round Off) and a vouchers file of Sales as Accounting Invoice. Under the buttons are the steps to import into TallyPrime, and below every file made earlier with its count of sales, credit notes and cancellations. An order TallyPrime did not take, or the module could not book (an unknown State, for example), is listed on its own with the reason.

The place of supply is the delivery State; with nothing shipped, the billing State; with no address, your own State. The same State gives half CGST and half SGST (UTGST in Chandigarh, Ladakh, Lakshadweep, Andaman & Nicobar and Dadra & Nagar Haveli and Daman & Diu), another State or an export gives IGST. The tax is split by the GST rate of each product, amounts are counted in paise and the rounding goes to Round Off, so the voucher always balances. If the shop spells a State its own way, set it in the settings; the usual spellings (Orissa, Uttaranchal, Pondicherry) are already known.

Pro lifts the file limit and sends vouchers straight to TallyPrime acting as an HTTP server (port 9000): from the order panel, in bulk for a period, or by itself when an order reaches a chosen status. If TallyPrime cannot be reached, the buyer checks out without errors and the voucher waits to be sent later by the cron. A credit note covers the whole order or the returned products from OpenCart Returns, a cancellation goes by status or button. Item invoices carry the products as stock items with unit and godown.

How it works, step by step

1. In the settings choose your GST State and GSTIN, the ledger names and the Sales voucher type.
2. Open the export page, pick the period and statuses and press “Make files”.
3. In TallyPrime: Alt+O (Import) → Masters with the ledgers file, then Alt+O (Import) → Transactions with the vouchers file.
4. Look at the result in the Day Book and the Sales Register.
5. In Pro enter the address of TallyPrime, and vouchers go there by themselves by order status.

Under the hood

• The TallyPrime XML import format from TallyHelp: Import Data, one object per TALLYMESSAGE.
• Sales voucher as Accounting Invoice, New Ref / Agst Ref bill, unique REMOTEID.
• PARTYGSTIN, PLACEOFSUPPLY, STATENAME and the GST registration of the customer ledger (LEDGSTREGDETAILS).
• Amounts in paise: CGST = half the tax, SGST = the rest, Dr = Cr.
• Anything non-ASCII is written as XML entities.
• OpenCart events, no core edits; the OpenCart cron for retries (Pro).
• Interface in English.

How to install

1. Extensions → Installer: upload the archive for your version without renaming it (OpenCart 4: cc_tally.ocmod.zip, 3.x: cc_tally-oc3.ocmod.zip, 2.3: cc_tally-oc23.ocmod.zip).
2. For 3.x and 2.3: Extensions → Modifications → Refresh.
3. Extensions → Modules → GST Sales Export for TallyPrime: install and edit.
4. Enter the State and GSTIN, the ledger names and save.
5. For Pro: paste the key or start the trial on the Licence tab.