Frequently Asked
Questions
Find Solutions to Common Issues Related to accounting-reports - account books
I want to check details of sales returns that were not captured correctly in the previous month. What should I do in BUSY?
To check the details of sales returns that were not captured correctly in the previous month, you need to follow the below steps:
Step 1: Go to Display, then Account Books, then Account Registers (standard), then Sales Return Register.
Step 2: After that, you will find the option of Sales Sales Return Register to be shown for all sales return types and one sales return type, then select the relevant option.
Step 3: After that, you will find the option of sales. Return the register for all parties, groups of parties, one party, and selected parties, then select a customer for whom you want to see the report.
Step 4: After that, you will find the option for a date range, then type the relevant date range of the previous month and select relevant information if required, press Y on that particular window, and then execute the report.
Step 5: After that, you will find your sales return register for all invoices for a previous month-specific date range in BUSY.
How to add custom column for e invoice field in sales register?
To add custom column for e invoice field in sales register you need to follow below steps:
Step 1: Go to Display, then Account Books.
Step 2: Under Account Books books option Click on Account Registers Standard
Step 3: Then click on Sales register option, then Select all parties and date range.
Step 4: After opening report, Click on Custom Columns at right corner.
Step 5: Add a new custom column format by giving any name.
Step 6: Then Click on Add New Col. then provide heading name as E Invoice No. of the column.
Step 7: Then Select Position, Data Type as Text, Alignment and Number of characters.
Step 8: Then Select the Field Value Details as Data Field and in that have to Select Category as Inventory Voucher Header.
Step 9: Further have to Click on Field and Choose EINVOICE_ACK_NO or EINVOICE_IRN field.
Step 10: Then Click on Save field and Save format and then reopen the sales report with New custom column format and you will get the einvoice acknowledgement number or einvoice IRN number column.
Reason behind if invoice not reflecting in customer’s ledger?
If we adjust/receive amounts while doing sales. Then we can use the settlement feature. Through which option we have settled the amount like Cash/Debit Card/Credit Card etc.
In this case, the transaction will not reflect in the ledger of the customer. In such case we can use an option of Post settlement data along with Party data. Then it will reflect the transaction in ledger report.
If invoice not reflecting in customer’s ledger follow the below steps:
Step 1:Administration=>configuration=>Voucher series configuration=>Select voucher type E.g. Sale, Purchase.
Step 2:Click on configuration tab and then in settlement configuration, enable post settlement data along with party data .
Step 3: After making corrections in the settlement configuration, resave the particular invoice and check the ledger report.
If the above is disabled then the adjusted amount will reflect in the account ledger that is tagged for settlement not in the concerned party ledger.
Remark - If advance POS data entry feature is enabled in particular voucher type then the settlement configuration will be configured from advance POS option.
What could be the reason for having mismatches in the sales ledger report with Gst sales register?
Sales ledger report will display data whose accounting post through sales account but Gst sales register will show taxable and tax value.
If you are having mismatches in the sales ledger report with Gst sales register follow the below steps:
Step 1: Compare Both Gst sales register and sale ledger report in short range and find the date in which mismatch occurred.
Step 2: Check the reason behind the mismatch.
Possible reasons for mismatch -:
1: Item belongs to a service in which another account is tagged instead of sales account master by which particular entry is not displayed in sales ledger book .
2: Bill sundry applied after tax whose amount was adjusted in sales ledger but not included in taxable value so the value will appear in sale ledger but not in gst sale register.
3: Bill sundry applied before tax so the value will be included in taxable amount but the amount not adjusted in sale ledger because of tagging of another account master in particular bill sundry.
I need to maintain separate bank accounts but consolidated reporting. How can I do this in BUSY?
BUSY lets you create and manage multiple bank accounts and generate a consolidated report for them. To view them can follow these steps:
Step 1: Go to Administration and click on configuration.
Step 2: Select Columnar Reports and click on Cash/Bank Book. Here, you can select up to five bank accounts that you want to check and save the settings.
Step 3: Now, go to the Display menu and select Account Books.
Step 4: Choose Cash/Bank Book and select Multiple column. Enter the date range and view the report. The report will show the transactions of each bank account in separate columns.
Alternatively BUSY has also a consolidated report option. To view that can follow these steps:
Step 1: Go to Display menu and select Account Summary and click on Consolidated Summary.
Step 2: Choose Account-wise and select Group of Accounts and in group name mention Bank Accounts as a group.
Step 3: Open the report after enter the desired date range. This report will show all banks Opening, Debit, Credit & Closing Balance.
Where can I find cash sales reports in BUSY
BUSY lets you create and manage multiple bank accounts and generate a consolidated report for them. To view them can follow these steps:
Step 1: Go to Administration and click on configuration.
Step 2: Select Columnar Reports and click on CashorBank Book. Here, you can select up to five bank accounts that you want to check and save the settings.
Step 3: Now, go to the Display menu and select Account Books.
Step 4: Choose CashorBank Book and select Multiple column. Enter the date range and view the report. The report will show the transactions of each bank account in separate columns.
Alternatively BUSY has also a consolidated report option. To view that can follow these steps:
Step 1: Go to Display menu and select Account Summary and click on Consolidated Summary.
Step 2: Choose Account-wise and select Group of Accounts and in group name mention Bank Accounts as a group.
Step 3: Open the report after enter the desired date range. This report will show all banks Opening, Debit, Credit & Closing Balance.
What types of reports can I generate using BUSY?
BUSY provides a variety of accounting reports 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.
To export data from BUSY, you can go to the respective report (e.g., Accounts, Inventory, etc.), select the desired data, and use the "Export" (ALT+E) option to export it in a compatible file format such as Excel, CSV, PDF & Google Sheet.
The software is taking a long time to process tasks like running reports. What can be done to improve performance?
If BUSY take too much time to open any reports then follow the given steps:
Step 1: Go to housekeeping Menu
Step 2: Then click on reindex data base
Step 3: Then Select you can proceed as I have latest backup then click on OK button to start the process.
Step 4: After completing the reindex process you can check the same report.
Step 5: If issue persist then click on check junk character option under house keeping menu
Step 6: Then Select second option and click on OK button
Step 7: Then select master or voucher one by one and check any junk character then remove it
Step 8: Then click on check incomplete vouchers option
Step 9: Then Select second option and click on OK to run this process.
Step 10: If any incomplete voucher exist then remove it by pressing F8 key
Step 11: Now you can check the same report if some speed has ben boosted or not.
What accounting reports can be generated and how to export data in BUSY?
BUSY provides a variety of accounting reports 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.
To export data from BUSY, you can go to the respective report (e.g., Accounts, Inventory, etc.), select the desired data, and use the "Export" (ALT+E) option to export it in a compatible file format such as Excel, CSV, PDF & Google Sheet.
How can we tag the schedule to prepare a balance sheet annexure report?
A Fixed asset annexure is a detailed report which shows the list of all fixed assets of a business that contains detailed information such as the opening value of a fixed asset , asset purchases/sale during the year and its depreciation whereas capital asset annexure report will show the opening balance of capital , capital introduced/withdrawal during the year and adjustment of profit.
Scheduling is required for both the report which is to be done from the ledger report.
To tag the schedule to prepare a balance sheet annexure report follow the below steps:
Step 1: Press Alt+L or go to display > account book >account ledger >select account master (Fixed asset account or capital account) > open the report.
Step 2: Press F6 shortcut key to input data for balance sheet schedule > select type .
Step 3: The annexure report will display data as per scheduling , go to display > final result > balance sheet > Annexure (fixed asset) and Annexure (Capital account) .
