Find Solutions to Common Issues Related to accounting-reports - account books
For Zone Wise , We can add the debtors state or if mention Zone wise as Party Group then can add Custom Column Field and Filter accordingly.
Pls Follow the Below Steps for Custom Column in Reports:
Step 1: Click on Custom Column Option
Step 2: Mention the Format Name
Step 3: Click on Add New Column or Add New Row
For New Column :
Step 1: Mention the Heading - State orAccount Group, Position - After which column want to show ,Data type Field - Text and Alignment as per your need.
Step 2: Select the Field Value - Data Field
Step 3: Select the Category - Inventory or Accounting Vouchers Header or Account Master
Step 4: Select the Field Name - Party State or Party Group
If you are using bill by bill feature in BUSY, then you reconcile your bills with payment by using these steps:
Step 1: Go to the Display menu and click on Account Books.
Step 2: Select Account Registers(Standard) and Choose Sales Register or Purchase Register.
Step 3: You can filter the report by party as One Party, All Parties, Selected Parties or Group of Parties.
Step 4: Enter the date range and set Y on Show Payment / Receipt Details.
Step 5: This report will show you the reciept payment amount with status.
Step 6: Also which bill payment is pending it will show in red color.
Alternatively you can also view Bills Receivable or Bills Payable report from outstanding analysis to check bill wise oustanding.
If you want to add columns to a report, you can do so through custom columns:
Step 1: Open your report. On the upper side, you will find the options for custom columns.
Step 2: Click on custom column, then give a name in the format name field.
Step 3: Mention the heading Name, position, data type, alignment, and character.
Step 4: In the field value details, choose the data field.
Step 5: In the data field option, choose the category.
Step 6: Then choose the column you want in the report.
Step 7: If you do not want to see any predefined column, untick the column.
Step 8: Save the field and format.
Step 9: Now reopen the report with the format name that you created.
BUSY provides several reconciliation and auditing features to review accounts and entries. These features include:
1. Bank Reconciliation: BUSY allows you to reconcile your bank statements with your accounting records. You can mark cheques as cleared or uncleared and enter the clearing date to ensure accurate reconciliation.
2. GST Reconciliation: The software provides a GST reconciliation feature that allows you to match your GST portal data with your accounting entries. This helps in identifying any discrepancies and ensures accurate GST reporting.
3. Audit Trail: BUSY has an audit trail feature that logs all user activities and changes made to transactions. This allows you to track who created or modified a transaction, providing transparency and accountability.
If you wants to check reports with tax bifurcations like sale or purchase register,follow these steps
Step 1 Go to display and then go to account books
Step 2 Go to account registers standard and then sale or purchase register
Step 3 Then select sale or purchase type and then party or group of parties
Step 4 Now select date range and enable show bifurcations of amounts and load the report
Step 5 Now you can check report including total sale or purchase,taxable and then breakup in cgst,sgst and igst and sale type
And also you can check in display sale or purchase register for tax bifuraction in gst reports as gst registers like sale or purchase registers
To see the payment adjustment details in vendor ledger you need to follow the steps
1 go to the transaction menu and click on purchase voucher type then select the
voucher from the list and open it
2 click on party name and press alter M to modify and enable Bill by bill maintain option
and save
3 then at the time of saving purchase voucher generate new reference number and save
4 then again go to transaction menu and click on payment
5 go to list of payment and select the payment voucher in which showing issue and adjust
the reference number at the time of saving with the purchase voucher to see the effect in ledger
If the purchase invoices are not displaying in their respective ledger, check the possible reasons:
1.Confirm that if the purchase invoice is posted with a zero value, it will not appear in the ledger report.
2.If a particular voucher has been canceled, it will also not appear in the ledger report.
3.Confirm that the correct party is selected in the purchase voucher, and make corrections if needed.
4.Check if any other account is incorrectly tagged in the item master instead of the purchase account. Correct the tagging if the wrong account is updated and then resave the invoice.
5.If the wrong account is tagged in the purchase type, correct the account tagging in the purchase account information field, and resave the invoice.
If you want to Add Custom Column, follow these steps:
Step 1: To do this, open your report. On the upper side you will find the options for custom columns.
Step 2: Click on custom column then give a name in the format name field.
Step 3: Mention the heading Name position, data type, alignment, and character.
Step 4: In the field value details choose the data field.
Step 5: In the data field option, choose the category.
Step 6: Then choose the column you want in the report & save.
Step 7: If you do not want to see any predefined column, untick the column.
Step 8: Save the field and format.
Step 9: Now reopen the report with the format name that you created.
If you notice that a sale entry you made in BUSY is not showing up in the sale ledger, it could be due to using a different account for the sale either in the sale type or within the item master. To fix this, you should check the account used and correct it if necessary. If the issue is with the account within the item master, you should correct the account master then reapply the item at voucher level. If the issue is with the account within the sale type, you should correct it and then resave the voucher. Once the corrections are made, the voucher should start to show up automatically in the sale ledger.
If Unit Price Not Showing in the Customized Purchase register, follow these steps:
Step 1: Open your report. On the upper side, you will find the options for custom columns.
Step 2: Click on custom column, then give a name in the format name field.
Step 3: Mention the heading Name, position, data type, alignment, and character.
Step 4: In the field value details, choose the data field.
Step 5: In the data field option, choose the category.
Step 6: Then choose the Unit column you want in the report.
Step 7: If you do not want to see any predefined column, untick the column.
Step 8: Save the field and format.
Step 9: Now reopen the report with the format name that you created.