Apr 24 2020 07:23 AM
ive set up an expenditure worksheet, part of which includes outstanding debt. Is there a way where either every month on a set date the outstanding debts will reduce or when I input my income on payday the outstanding debts will auto update rather than me having to manually deduct the debt repayments from them?
Many thanks
May 13 2020 12:51 AM
@rutterc85 You can simply create a separate column for income/collection and put a formula to deduct the from Outstanding Amount. Simple Deduction formula can be used to get the latest data of Outstanding.