To help best manage your accounts payable, here are some things to know about the payment and funds transfer workflow between Bill.com and Microsoft Dynamics 365 Business Central (MSDBC).
Purchase invoice/bill sent payments
- Payments need to be posted in MSDBC.
- Payment voids don't sync. Void in Bill.com and MSDBC manually.
- Update your payment GL accounts to Bank account type in Bill.com so they can be used for payments and sync preferences.
- Any time you add a new bank account in MSDBC, you’ll need to change the type to Bank in Bill.com before you can use it for payments.
- Create a new journal in Microsoft Dynamics Business Central so you can track Bill.com payments separately: Payment Journal - Name: BDC_PJ
- Sync to the Payment Journal selected in sync preferences.
- Payments won't sync to MSDBC unless the purchase invoice is posted.
- Sync to the Payment Journal selected in sync preferences.
Sales invoice received payments
- Payments need to be posted in MSDBC.
- Payment voids don't sync. Void in Bill.com and MSDBC manually.
- Update your payment GL accounts to Bank account type in Bill.com so they can be used for payments and sync preferences.
- Any time you add a new bank account in MSDBC, you’ll need to change the type to Bank in Bill.com before you can use it for payments.
- Create a new journal in Microsoft Dynamics Business Central so you can track Bill.com payments separately: Cash Receipt Journal - Name: BDC_CRJ
- Sync to the Cash Receipt Journal selected in sync preferences.
- Payments won't sync to MSDBC unless the sales invoice is posted.
- Sync to the Cash Receipt Journal selected in sync preferences
Funds transfers
- Bill.com uses the Money In and Money Out Clearing GL Accounts to help with bank reconciliation. Because GL accounts only sync 1-way from MSDBC to Bill.com, you'll need to create these accounts in MSDBC, then change to bank type in Bill.com.
- Create a new journal in Microsoft Dynamics Business Central so you can track Bill.com funds transfers separately: General Journal - Name: BDC_GJ
- Sync to the General Journal selected in sync preferences.