Automated bookkeeping of business data
Last updated
Last updated
This page illustrates how to set up and manage automated bookkeeping rules in the Business Data Automation module, including adding, executing, editing and deleting rules.
On the project homepage, navigate to the Transaction page.
In the Transaction page, select the Automation tab on the upper side of the page.
Select the "Business Data -> Journals" sub-tab.
Click the "+ Add Rule" button on the upper right corner of the page.
Enter a name for the rule.
Select the integration type for the business data.
Configure the conditions for which the business data will be filtered and processed based on.
Select the type of journal entries to create for business data that meets the configured conditions.
Input the value computations for the required journal entries; for currency, auxiliary accounting fields, etc. You can select specific columns from the business data. For numerical values, you can either select a column or input a formula.
Save the automated bookkeeping rule.
Click the "Manually execute all rules" at the upper right corner of page to execute all rules.
You can also click the "play" icon beside each rule to execute that individual rule.
Once the journals have been verified and confirmed on the Ledger page, click on the Post to Ledger button on the upper right corner of the page.
Click on the "pencil" icon next to the rule to open the Edit Rule window.
After updating the rule, re-run it to generate new journal entries replacing the original existing journal entries.
Click on the "thrashcan" icon next to the rule to trigger deletion
Deleting the rule will not delete the journal entries that were generated based on this rule.