Step 1: Select the Uploaded File

Choose the required Excel file from the Sales Excel Inbox to access its transactions.

Opening the correct file allows you to review sales entries, complete ledger mapping, and perform advance payment set-off before pushing entries to Tally.

Step 2: Select the Party Ledger

Assign or select the appropriate party ledger for the transaction.

Once the party ledger is selected, the Set-Off section becomes available, allowing you to adjust previous advance payments against the current invoice accurately.

Step 3: Open the Set-Off Window

Under the Action column, click the Set-Off icon.

This opens the set-off window where you can manage outstanding references, link advances, and reconcile customer balances before processing the sales transaction.

Step 4: Select Against Reference

Click the Against Reference icon inside the Set-Off window.

This displays all eligible advance payments that were created before the invoice date, making it easy to allocate advances to the correct sales invoice.

Step 5: Choose the Advance Entry

From the pop-up list, select the relevant advance payment to adjust against the current invoice.

Matching the correct advance ensures accurate customer accounting, outstanding balance reconciliation, and proper reference management in Tally.

Step 6: Enter the Set-Off Amount

Enter the amount to be adjusted against the selected advance payment.

If the invoice amount exceeds the advance, the remaining balance is automatically recorded as a New Reference, ensuring accurate receivable tracking.

Step 7: Save the Set-Off Details

Click Save to confirm and record the set-off information.

Saving preserves the reference mapping and prepares the transaction for final review or posting without losing the adjustment details.

Step 8: Complete and Process the Entry

Your set-off details have been successfully saved.

You can now complete any remaining transaction details and choose to Push to Review or Push to Tally, ensuring accurate accounting records with properly adjusted advance payments.

Simplify Advance Payment Set Off

The Set-Off feature helps businesses automatically reconcile advance receipts with sales invoices, reducing manual adjustments, improving customer outstanding management, and ensuring clean accounting records in Tally.

How to set off advance payments against invoices in sales excel module?