Stand in the Amount column. Positive amounts become Debit and negative amounts become Credit.
Assist Pro + → Resources → Finance Tools → Accounting Tools → Amount to Debit / Credit
Part of Assist Pro+. Eligible tools can also be selected through Assist Pro’s 30-tool Vault allowance. Check the Vault for availability.
Open the tool and follow its prompts. Use a copy of your workbook when trying an action for the first time, then check the result.
Browse all toolsChoose the accounting schedule or source-column range you need to calculate or inspect. On Assist Pro + › Resources › Finance Tools › Accounting Tools, choose Amount to Debit / Credit to stand in the Amount column. Positive amounts become Debit and negative amounts become Credit. Compare the calculation or reference to the actual transaction, agreement or applicable guidance.
Separating positive and negative accounting amounts into separate DR/CR fields.
Speeds preparing or checking tax, depreciation, lease and ledger calculations by helping positive amounts become Debit and negative amounts become Credit.