Frequently Asked
Questions
Find Solutions to Common Issues Related to accounting-reports - account books
How do I customize or edit existing reports?
To customize or edit the existing report you can use custom column feature but you need
to ensure that you are using standard or enterprise model and your user ID have the permission
to edit custom column
To add custom column in existing report you need to follow the steps
1 open the existing report and click on custom column
2 type a new name for the report then click on add column and fill a header name then set the
position of column and type as text
3 then select data field and click on category and select the options from where the data will pick
then click on field and select the option and field from the list which you want to add as a custom column
4 save the field and save the format
5 then open the same report with new format name
Reconcile bank statement in BUSY step-by-step.
To reconcile a bank statement in BUSY, follow these steps:
Step 1 : Go to the "Banking" option in BUSY from accounts.
Step 2 : Select the bank account you want to reconcile.
Step 3 : Click on the "Reconciliation" option.
Step 4 : Enter the statement date and closing balance from your bank statement.
Step 5 : Review the list of transactions in BUSY and compare them with your bank statement.
Step 6 : Mark the transactions that match by checking the box next to them.
Step 7 : If there are any discrepancies, investigate and correct them.
Step 8 : Once all transactions are matched or corrected, click on the "Reconcile" button.
Step 9 : Verify that the closing balance in BUSY matches the closing balance on your bank statement.
Step 10 : Save the reconciliation and generate a reconciliation report for your records.
How do I reconcile my accounts if the balances don't match my records?
To reconcile your accounts when the balances don't match your records, you can follow these steps:
Step 1 : Review your transactions: Check all the transactions recorded in your accounts, including deposits, withdrawals, and any adjustments made.
Step 2 : Verify opening and closing balances: Ensure that the opening and closing balances in your records are accurate and match the actual amounts.
Step 3 : Check for data entry errors: Look for any mistakes in entering transaction amounts, dates, or account numbers. Correct any errors you find.
Step 4 : Match transactions: Compare your bank or financial institution statements with your records to identify any missing or duplicate transactions. Make sure all transactions are accounted for.
Step 5 : Reconcile discrepancies: If you find any discrepancies, investigate the cause and make the necessary adjustments to bring your balances in line with your records.
How do I customize sales registers to add custom columns?
To add a custom column in sale register follow the steps
1 go to display menu and click on account books then click to account register standard
2 then click to sale register
3 then select all sale type all party select the date range and enable bifurcation of amount and ok
4 then click on custom column
5 type a new name for the report then click on add column and fill a header name then set the
position of column and type as text
6 then select data field and click on category and select the options from where the data will pick
then click on field and select the option and field from the list which you want to add as a custom column
7 save the field and save the format
8 then open the same report with new format name
I made a purchase return entry but it is not reflecting correctly. What could be the reason?
To fix issues with your purchase return entry in BUSY:
1:Enable Posting:In the administration menu, go to Configuration under Features and enable posting in accounts through sales return and purchase return. Save changes.
2:Adjust purchase Voucher:Open the Purchase return voucher in modify mode.
3:Tag original purchase voucher details and adjust the bill reference with the original purchase voucher.
4:Check purchase return Register:Navigate to display, click on Account Books, and select purchase return Register.
5:Choose all sale types and parties, fill in the period, and click Ok.
6:Verify User Rights:Ensure the user has sufficient rights to view purchase return data.
7:Approve Pending Vouchers:If there are pending vouchers for approval, approve them. The entry should reflect automatically.
8:Check Date Range:Confirm you are checking data in the correct date range.
Following these steps will help address issues with the accurate reflection of purchase return entries in BUSY.
I want sales data for all accounts together. How can I view aggregated sales data?
To view aggregated sales data for all accounts together in BUSY, you can use the Sales Register / sale analysis option.
Please follow the below steps:
Step 1 : Go to Display menu
Step 2 : Click on Account Book / inventory books( with inventory details if you want to check sale report)
Step 3 : Account register standard / Inventory register standard
Step 4 : Click on Sale register
Step 5 : Open the Sales Register with all parties and select the desired date range, . This will display the sales data of all parties in one report.
Please follow the below steps for sales analysis:
Step 1 : Go to Display menu
Step 2 : Click on sale analysis
Step 3 : You can check party wise option or you can select any other option as per your requirement.
How can I look up invoice history for the last days?
To check the invoic history of last 5 days, please follow the below mentioned steps:
Step 1: Go to administration then configuration.
Step 2: Click on Feature & options then go to Inventory tab.
Step 3: Check the option of show last trasactions during sales and mention the number of days as 5.
Step 4: Click on save button and quit from there.
Step 5: Now you can check the invoice history during the entry of voucher.
Further if you want to check the report separately, can also refer the reports mention in below steps.
Step 1: Go to display menu then click on Account or inventry books.
Step 2: Click on day book and filter on date range in which you want to check.
Step 3: Enable or disable the options accordingly and now open the report s.
Step 4: It will take some time if have many vouchers, now check.
How do I customize reports to add additional columns or details?
To add additional columns in BUSY reports, you can follow these steps:
Step 1: Open your company then, the desired report that you want to add a column to.
Step 2: Click on Custom Column in the report’s header part.
Step 3: Create a Format Name and click on Add New Col. Enter the details such as heading, position, data type, etc. for the new column.
Step 4: Select a category and click on Fields. Search for the field that you want to add and select it. Save your changes.
Step 5: Reopen the report with the format name that you created. You will see your new column with the appropriate data.
The Custom Column feature is only available in the Standard and Enterprise editions of BUSY. If you are using the Basic edition, you can add columns by using the Columnar option from the configuration tab under Administration.
How do I reconcile the ledger
BUSY has a "Ledger Reconciliationfeature that helps you to match your ledger entries with your books. You can use this feature to verify the accuracy and completeness of your accounting records. To use this feature can follow these steps:
Step 1: Open BUSY and select the company you want to work with. Then, go to the Administration tab and click on configuration.
Step 2: Under Configurations, select Features / Options and then click on the Accounts tab. Here, you will find the Ledger Reconciliation option. Just click on the checkbox to turn it on.
Step 3: To open your ledger, press ALT+L and choose the account ledger that you want to reconcile.
Step 4: Enter the date range for the reconciliation and select Y for Enable Reconciliation.
Step 5: In the report, you can press F4 to reconcile each entry. You can also add remarks if needed.
What would be the reason behind the entries in the sales register being shown in red colour?
If the entries in the sales register being shown in red colour check the below steps:
Step 1: Go to Display >Account Books >Account Register (Standard ) >Sale register
Step 2: open the report after enabling show payment/receipt details , the entries whose payment/receipt are pending that will appear in red colour.
Remark - Above option is linked with the Bill by Bill Details feature.
Bill by Bill Details ( administration > configuration > features and option >account tab )
Through the Bill by Bill feature , a bill reference along with due date can be maintained for a single transaction that helps in tracking the due dates when the payment is due and also show reports for pending bills , cleared bills , due bills and so on.
Video link for Maintaining Bill by bill - Maintain Bill by Bill details in BUSY (Hindi)
