Find Solutions to Common Issues Related to taxation - gst reports
To fix the issue of downloaded GST reports showing wrong dates, you can try updating the data or checking if the correct date range has been selected. Also Check BUSY latest version and Release.
To generate accurately GST Returns report in BUSY.
Step 1: Check BUSY latest version and Release.
Step 2: Take Backup.
Step 3: Go to House - Keeping Menu.
Step 4: Click on Update Master Balances
Step 5: And Run update master balances & update voucher GST Summary.
Step 6: Go to Display Menu.
Step 7: Click on GST Reports option.
Step 8: Click on GSTR-1 GSTR-3B and select required options Starting date & Ending date.
Step 9: Click on OK
Step 10: Verify GST Configuration Settings.
Step 11: Cross-Check Input Data. Double-check the data entered for GST transactions. Ensure that all relevant details are accurately recorded to reflect in the GSTR-3B report.
Step 12: If you want return GSTR1 direct from BUSY select GSTR-1 e Return, and to generate GSTR-3B JSON file select e Return GSTR-3B.
BUSY provides a variety of reports under the Display menu to help you manage your business finances effectively. Some of the reports are:
1. Financial Reports: These include Balance Sheet, Profit & Loss Account, Trial Balance, etc.
2. Account Books: These include Account Ledger, Sales Register, Purchase Register, etc.
3. GST Reports: These include GSTR-1, GSTR-2, GSTR-3B, GSTR-4, GSTR-9, etc. These reports help you to comply with the GST laws and regulations in India.
4. Outstanding Analysis Reports: These include Bills Receivables, Bills Payables, Aeging Reports, etc. These reports help you to manage your cash flow and credit control.
5. MIS Reports: These include Profitability Report, Cash Flow, Fund Flow, Ratio Analysis, Multi Company Results, etc. These reports help you to measure and compare the performance of different segments of your business.
6. Inventory Reports: These include Stock Status, Inventory Books, Inventory Summary, etc. These reports help you to track your inventory level.
To generate them open the required report and use the Export (ALT+E) option to export it in a compatible file format such as Excel, CSV, PDF & Google Sheet.
To fix sales discrepancies between P&L and tax filings, you need to ensure that all sales are accurately recorded in your accounting software and that the correct tax rates are applied. It is important to reconcile your sales data regularly and ensure that it matches with your tax filings. If you notice any discrepancies, you should investigate and correct them promptly.
you can check the reconcile report. follow the step:
Step 1: Go to Display Menu.
Step 2: Click on GST Reports option
Step 3: under GST Reports click on GST Audit Reports.
Step 4: Click on Reconcile Accounts & GST report option.
Step 5: Select Specify the reconciliation type for Sales, Purchase, and Account Vouchers.
Step 6: Example If you choose Sales you will open reconcile window.
Step 7: Select required option voucher series, date range and click on OK.to generate the report.
Step 8: Review Reconcile GST and Account Sales Report
Step 9: If any issues are identified in the report, take the necessary steps to correct them promptly.
The reason for not being able to view some invoice details in GST reports in BUSY may be
due to the following cases
1 If the sale type mentioned in voucher is skipped in gst reports then the sale voucher will
not show in gst reports to solve the issue follow the steps
go to transaction menu click on sale and click on modify then search voucher which is not showing in gst reports and open it then click on sale type and press alter M and make N on
skip in gst reports option
2 If the item master mentioned in voucher is tagged with different ledger without sale then it will
not show in gst reports to solve it follow the steps
go to transaction menu click on sale and click on modify then search voucher which is not showing in gst reports then select the item master and check if there is any specicy sales account mentioned on it then change it to sale or make it not required and save
To generate reports for a custom date range with specific date filters, you can specify the periods by selecting the start and end dates for the desired range. This can be done in the report generation settings or by using the filter options to narrow down the results to the desired time period. In Every GST Report have option of selection Date range for example we want to generate Sales Register with date range. Kindly follow the following steps
Step 1: Go to Display Menu.
Step 2: Click on GST Reports option
Step 3: Under GST Reports click on Sales Register option.
Step 4: Choose the option register to be shown as Local, Central, Combined.
Step 5: Selected Combined option.
Step 6: click on Bill-wise option
Step 7: Select Both B2B and B2C option.
Step 8: on sales register (Bill-Wise) report window you will get Date range option.
Step 9: Choose option as you required Voucher Series, Account Master Range, Date Range.
Step 10: Click on OK. Confirm your selections and generate the Sales Register report with the specified parameters.
There are various GST reports available in BUSY such as GST Summary, GST Register, GSTR-1, GSTR-2, GSTR-3B, and more. These reports provide information on different aspects of GST such as outward supplies, inward supplies, tax liability, input tax credit, and more. Understanding these reports can help businesses in filing their GST returns accurately and on time.If we Talk about Pending Term it means the status or your input that you will claim and till now you did not claim it and it is showing in pending in Report of Monthluy ITC Tagging and to claim it you can follow some steps:
Step 1: Go to the Transaction and click on GST Mis.Utility.
Step 2: Now click on Monthly ITC Tegging as per GSTR 2A or 2B and then select period and enable other option there as per your requirement and check report.In monthly ITC tegging report You can checked ITC Status for your voucher.
Step 3: Now for the Pending ITC Status give climed status if you want by click F4 key and specify status and period.
If you are unable to see the reflection of your GST adjustment in GST reports you need to ensure below mentioned points:
1. Gst nature of those journal entries should be correct
2. Ledger you have selected should be correct
3. Group of ledger should be correct
4. Amount gst specified in ledger of those entries should be correct and should be equal to actual gst
5. Make sure all adjustment enries should be correct otherwise it will leads to mismatch
6. Make sure you are using current and latest release of BUSY
To sync your BUSY software with gst for matching of BUSY data with GSTR data follow these steps:
To sync your GST portal and BUSY
you can follow these steps:
Step 1: Go to administration menu then Click on Configuration option
Step 2: Then click on features and options
Step 3: Now Click on gst/vat button
Step 4: Now mention the gst portal username and click on save button to save it.
Step 5: Your GST login successfully synced with the software
If the Audit Trail feature is enabled in your company, then you can review changes made by using these steps:
Step 1: Open BUSYand select the company you want to work with. Then, go to the Display tab and click on Check List.
Step 2: Select Audit Trail, then you can select the Details to be shown such as Accounts Day Book, Inventory Day Book, Payroll Day Book, Other Vouchers and List of Master. This will determine the type of transactions and masters that you want to see in the report.
Step 3: Select the User from the drop-down list. You can choose between All Users or a Specific User. This will filter the report by the user who made the changes in BUSY.
Step 4: Select the Entries to be Shown from the drop-down list. You can choose between Added, Modified, Deleted, and Other Info. This will filter the report by the action that was performed on the transactions or masters in BUSY.
Step 5: Enter the Date Range for which you want to see the report .
To upload GST returns on government portal from BUSY, you need to follow the below steps:
Step 1: Check BUSY latest version and Release.
Step 2: Take Backup and Go to House - Keeping Menu, Click on Update Master Balances and Run update master balances & update voucher GST Summary.
Step 3: Go to Display Menu, Click on GST Reports option, Click on GSTR-1 GSTR-3B and select required options Starting date & Ending date, Click on OK
Step 4: Verify GST Configuration Settings.
Step 5: Cross-Check Input Data. Double-check the data entered for GST transactions. Ensure that all relevant details are accurately recorded to reflect in the GSTR-3B report.
Step 6: Select GST Returns and choose the return options the you want to generate such as GSTR-1 eReturn, GSTR-3B eReturn, etc.
Step 7: Select Report to be generated options such as Direct Upload, JSON, CSV File, etc.( Direct Upload option is currently available for GSTR-1 only).
Step 8: Enter the period and can generate GST Returns according to the option selected.
To rectify the taxable amount in GSTR ! with the actual sales, you may refer the following steps:
Step 1: Go to GST Reports then click on GST Audit reports.
Step 2: Select reconcile account with GST then select sales.
Step 3: Enable the options as pr your requirement.
Step 4: After opening the report rectify the entries if shown the same report.
Step 5: Or you can also reconcile GSTR 1 JSON data with books of accounts by downloading the same.
Step 6: Go to transaction menu then click on GST miscelleneous utilities.
Step 7: Click on download GSTR JSON data then select download GSTR 1.
Step 8: Click on downlod tab for those months for which you want to reconcile and download the JSON data.
Step 9: Again go to transaction menu then click on GST miscelleneous utilities.
Step 10: Click on reconcile GSTR data then select reconcile GSTR 1.
Step 11: Enable or disable the options as per your requirement.
Step 12: Now you can also match the values of GSTR ! and books of accounts.