💡 In Douano, you can import your bank transactions via the MyPonto plugin. This allows invoices to be matched semi-automatically, eliminating the need for manual reconciliation.
💡 Want more info about MyPonto? Click this 👉 link.
💡 Want to get started with this plugin? Follow this 👉 guide.
⇢ Go to Invoicing – Bank Transactions.
💡 Bank transactions are imported every morning and afternoon.
💡 Before assigning transactions to invoices, first remove any transactions that are not related to Douano by either manually ignoring them or using an Assignment Rule.
Ignoring bank transactions
Manually ignoring
A bank transaction can be ignored once by clicking the green eye icon on the transaction line.
Ignoring with an assignment rule
💡 Bank transactions that do not belong in Douano can be automatically ignored using an assignment rule.
Open the bank transaction by clicking its line. Via the menu icon in the top right, click Create bank assignment rule.
In the popup, review the details and optionally add a description for the fields General and Criteria.
You can also create a rule for this account number that accounts for a specific reference or amount.
Now ignore this transaction manually once by clicking the Ignore button at the top.
💡 The next time you bulk-assign incoming transactions, Douano will automatically ignore transactions from this account number.
💡 You can find your created assignment rules under Settings – Billing – Bank Transaction Assignment Rules. More info is available in this 👉 guide.
Assigning and booking bank transactions
Bulk assignment and posting
💡 After ignoring irrelevant transactions, only the transactions that need to be linked remain. These can now be bulk-assigned.
Under the To be assigned tab, click Bulk auto-assign via the menu icon in the top right and confirm. Douano will attempt to match the transactions with invoices based on parameters such as account number, reference, amount, etc.
Transactions that Douano could automatically match with an invoice appear under the Assigned tab. You can now bulk post these by clicking Bulk post via the menu icon in the top right and confirming in the popup.
Manual assignment
💡 Transactions for which Douano cannot find enough information remain under To be assigned.
💡 These can be posted manually. Over time, Douano will learn from these assignments, increasing the number of transactions automatically matched in the future.
Click a transaction to open it.
In the Assignments field, you can search by company or invoice.
Once the correct invoice is found and the total amount matches, you can post the transaction.
💡 If the account number for this customer is not yet entered in the company’s form, Douano will suggest adding it. This ensures future transactions for this customer are automatically assigned.
What if the total amount doesn’t match?
Posting the received amount
💡 If the transaction amount does not match the invoice amount, you can post the received amount. The invoice will still display the remaining open balance.
Click a transaction to open it. In the Assignments field, search by company or invoice.
Adjust the amount to match the transaction amount and post.
Remaining amount as a discount
💡 If the transaction amount slightly differs from the invoice and you want to post the invoice in full, you can record the difference as a discount.
Click a transaction to open it. In the Assignments field, search by company or invoice.
Adjust the first line to the amount received via the transaction.
On the second line, select the invoice again and enter the remaining amount. For Assignment Type, select Discount.
💡 In Billing – Sales Invoices, the invoice will show as posted for the full amount.