Sales Tax Filing Adjustments
Sales Tax adjustments play a crucial role in ensuring accurate tax reporting and compliance for businesses using XoroERP. These adjustments allow users to fine-tune tax liabilities and ensure that financial statements reflect the correct tax obligations. This overview provides a step-by-step guide on how to make Sales Tax Filing Adjustments within the XoroERP system and highlights the benefits of this process for users.
Benefits of Making Sales Tax Filing Adjustments
Accurate Tax Reporting: Adjustments enable businesses to rectify any errors or discrepancies in tax filings, ensuring accurate reporting to tax authorities and avoiding penalties or fines due to incorrect tax calculations.
Compliance Assurance: By making adjustments during the filing process, businesses can ensure compliance with tax regulations and maintain transparent financial records, which are essential for audits and regulatory assessments.
Financial Transparency: Adjustments help maintain financial transparency by reflecting the true tax liabilities of the business, providing stakeholders with an accurate view of the company's financial health and tax obligations.
Cost Savings: Correcting tax liabilities promptly through adjustments can prevent overpayment of taxes, leading to cost savings for the business and optimizing financial resources.
How to Make Sales Tax Filing Adjustments
Navigate to the Prepare Sales Tax Module: Access the Prepare Sales Tax module within XoroERP to initiate the process of making Sales Tax Filing Adjustments.
Select Tax Return to be Adjusted: Under the Adjust column in the module, click on the pencil icon corresponding to the Tax Return that requires adjustments. This action will allow users to modify tax liabilities for specific returns.
Add Adjustment Amount: Enter the desired Adjustment Amount based on the corrections needed for the tax return. This amount represents the change in tax liabilities that need to be adjusted.
Choose Adjustment Account: Select the Adjustment Account, which serves as the offset account against which the tax liability adjustments will be created. The adjusted amount will be credited from the tax liability account and debited to the chosen offset account.
Finalize Adjustment: Once the adjustment amount and account are specified, finalize the adjustment process. The system will reflect the updated tax liabilities in the Amount column, ensuring accurate reporting and compliance.
When making Sales Tax Filing Adjustments in an ERP system like XoroERP, it's important to understand the role of the adjustment account from an accounting perspective. The adjustment account serves as the offset against which you adjust your tax liability. Here's a detailed explanation:
Offset Account Purpose: The adjustment account acts as a holding account to record changes in tax liabilities. When you enter an adjustment amount, it is credited from the tax liability account and debited to the offset account you choose. This ensures that the adjusted amount is appropriately accounted for and does not affect the original tax liability directly.
Handling Adjusted Amount: The adjusted amount remains in the offset account until further action is taken. This segregation allows for clear tracking of adjustments and prevents confusion with regular tax liabilities. It also maintains the integrity of financial statements by reflecting accurate tax positions.
Consideration for Sales Tax Expense Account: You might wonder if it's better to use a sales tax expense account on the Profit and Loss (P&L) statement for adjustments. However, from an accounting standpoint, sales tax is not an expense incurred by the business. Instead, the business acts as a collector of sales tax on behalf of the government.
Sales Tax as a Liability: Sales tax collected from customers represents a liability to the government until it is remitted. Therefore, it's more appropriate to record adjustments in an offset account rather than treating sales tax as an expense on the P&L statement. This approach aligns with accounting principles and accurately represents the financial position of the business.
In summary, the adjustment account in Sales Tax Filing Adjustments serves as a temporary holding account to manage changes in tax liabilities. It ensures proper accounting treatment of adjusted amounts and maintains clarity in financial reporting. Treating sales tax as a liability rather than an expense reflects the business's role as a tax collector and facilitates accurate financial statements.
How can I apply an overpaid sales tax amount to a future sales tax liability?
If you have overpaid sales tax for a filing period, XoroERP allows you to carry the excess amount forward and apply it to a future sales tax liability by creating a Sales Tax Adjustment. This ensures the overpayment is properly recorded, tracked, and reflected in subsequent tax filings.
How to Record the Overpayment
Navigate to Menu → Accounting → Sales Tax → Prepare Sales Tax.
Locate the tax return for the filing period containing the overpayment.
Click the Adjust (pencil) icon next to the applicable tax line.
Enter the adjustment amount representing the overpaid tax.
Select the appropriate Adjustment Account, which acts as the temporary offset or holding account for the overpayment.
Complete and finalize the sales tax return.
When the adjustment is saved, XoroERP records the accounting entry as follows:
Account
Entry
Debit
Adjustment Account
Credit
Sales Tax Liability Account
This entry reduces the outstanding sales tax liability while recording the overpayment in the designated adjustment account.
Applying the Credit to a Future Filing
When preparing your next sales tax return:
Open Prepare Sales Tax for the new filing period.
Review the Balance column, which displays any balance carried forward from previous tax periods.
Verify that the carried-forward credit is applied against the current sales tax liability before finalizing the return.
This ensures the overpaid amount is used to reduce the amount payable in the subsequent filing period.
Tracking Sales Tax Adjustments
To review and audit tax adjustments, navigate to:
Menu → Accounting → Sales Tax → Tax Adjustment Centre
The Tax Adjustment Centre provides a centralized view of all sales tax adjustments, including:
Sales Tax Account
Adjustment Account
Adjustment Date
Adjustment Amount
Tax Line
Memo
When recording an adjustment, it is recommended to include a clear memo describing the reason for the overpayment and the filing period it relates to. This improves traceability and simplifies future reconciliations.
Best Practices
To maintain accurate tax records:
Use the Tax Adjustment feature to record overpayments instead of manually modifying General Ledger balances.
Include descriptive memos indicating the filing period and reason for the adjustment.
Reconcile the adjustment against the appropriate Sales Tax Liability Account before filing the next return.
Confirm that the Net Tax Payable shown in the sales tax return matches your expected liability after applying the carried-forward credit.
If the overpayment is due to a tax refund, jurisdiction-specific rule, or another exceptional circumstance, consult your organization's controller or tax advisor to determine the appropriate accounting treatment.
Business Use Case
Scenario: Applying a Sales Tax Overpayment to the Next Filing Period
A business discovers that it has overpaid $500 in sales tax for the current reporting period. Rather than requesting a refund, the business chooses to apply the excess amount toward its next sales tax payment.
Using the Prepare Sales Tax module, the accounting team records a Sales Tax Adjustment for the overpaid amount and assigns the appropriate Adjustment Account. The adjustment is automatically tracked in the Tax Adjustment Centre, providing a complete audit trail of the transaction.
When preparing the next sales tax return, XoroERP displays the carried-forward balance, allowing the accounting team to apply the credit against the new tax liability. This streamlined workflow ensures the overpayment is accurately recorded, easily traceable, and correctly reflected in future tax filings while maintaining accurate General Ledger and sales tax records.
If a GST-inclusive bill is entered with a date in a tax period that has already been filed, how does Xoro handle the GST?
Xoro does not reopen or change the previously filed return. If the organisation allows posting into a filed tax period, the backdated bill can be entered and its GST is recorded as a tax exception. The exception is then included in the next Prepare Tax Return calculation and can be reviewed under Exception Amount or Tax File Centre → View Exceptions.
Workflow
Enter the bill with its actual February date and GST treatment.
If posting is allowed, it saves as a tax exception.
The February period remains closed; Xoro does not allow it to be filed again.
In the next Prepare Tax Return, review Exception Amount; it is included in the total.
In Tax File Centre, use View Exceptions to review carried-forward items. They are closed when the next return is filed.
In simple terms
The lodged February return stays unchanged. If the bill is allowed, its GST goes into the next return as an exception; otherwise the February-dated bill is blocked.
What happens if a bill is backdated to a tax period that is locked or filed?
If the filed tax period is locked, Xoro blocks the backdated bill rather than automatically moving its GST to the next return. If posting is permitted, the GST is carried forward as an exception into the next tax return; the previously lodged return remains unchanged. Whether the GST should be amended in the filed return or reported in a later period should be confirmed with the customer’s accountant or tax adviser.
Last updated
Was this helpful?