GST and credit note reconciliation, without the spreadsheet

Credit notes matched to what actually came back

Every invoice with a return on a picklist is covered by a credit note before the batch can be submitted, and any shortfall becomes a return value shortage for the executive to approve.

Companies that revise the bill instead

Some principals revise the bill for returns instead of issuing credit notes. That is set per company, the revised bill amount is recorded for each returned invoice, the same reconciliation and approvals follow, and reports use the revised amount.

GST Sales Register, matched line by line

Each line of the filed register is matched on invoice or credit note number and amount.

• Matched, mismatched, and what is only on one side
• Output GST from the register’s own tax figures
• Missing invoice numbers in each bill series, month by month
• A clean period locked so it stays closed

What if a company revises the bill instead of issuing a credit note?

The company is set to “Revised bill”. The revised amount is then recorded for each returned invoice, and GST reconciliation matches against it.

What if a credit note is less than the return?

The difference becomes a return value shortage, which the executive approves before the batch closes.

Which GST file is used?

An Excel or CSV export of the GST Sales Register, with or without a tax-slab breakup.