Accounts Receivable (NetSuite)

the accounts receivable cash application matches open invoice data synced from netsuite against new deposits included in the daily previous day reporting (pdr) import from {{yourbank}} deposits and their suggested matches are presented for review and approval a confidence level is presented for system matched invoices suggested matches can be approved as is, edited before approving, or removed entirely before excluding the deposit deposits without suggested matches can be manually matched to open invoices and approved or excluded as is upon approval of a match, the corresponding customer payment is posted to the erp and payment is applied to the associated invoices this action will also mark the customer payment as paid and trigger the associated accounting entries in the erp the solution supports one to one, one to many, and many to one deposit to invoice matching short pays due to invoice early payment discount terms, bank fees levied by the sending financial institution, and foreign monetary exchange are all supported use cases all cash application activity including new deposit matching, manual or automatic rematching, approvals, exclusions, customer payment posting, and errors are recorded and presented both in a dedicated history tab, as well as a per deposit action log accounts receivable user experience flow access receivables deposits page once your company has been onboarded to the receivables feature, you'll be able to access your open deposits and auto matched invoices navigate to {{productname}} > receivables > deposits navigating to the receivables deposits page open deposits list open deposits have been auto matched against open invoices and are awaiting review and approval each deposit card shows the deposit details on the left and the matched invoice details on the right the portion of deposit amount auto matched to open invoice amounts is indicated by a bar the matched amount is the portion of deposit matched to open invoices, and difference is deposit amount outstanding that has not been auto matched to open invoices the pagination component can be used to navigate across pages in the list open deposits list view deposits list filter toggle the filters drawer by clicking on show filters and hide filters the deposits list can be filtered by bank account , deposit amount , customer , and deposit date individual filters can be removed by clicking on the minus sign to the right of each filter clicking on reset will remove all active filters filtered deposits list view deposit details clicking on a deposit card displays the deposit details the deposit's amount , settlement date , sender , description/memo , bank account , and bank reference are displayed on the left the matched invoices are displayed on the right along with auto match confidence level (very low to very high), due date , invoice amount , amount due , discount taken , and amount matched for each invoice any relevant discount terms set in the erp are displayed for each matched invoice the discount taken field can be manually edited to any value between 0 and the amount due for the invoice the amount matched can be manually edited to any value between 0 and the amount deposited for the invoice deposit details view edit matches and filter open invoices matched invoices can be removed by hovering over an invoice and clicking the minus sign to the right of the invoice clicking on clear matches will remove all matched invoices at once deposit details view with invoice highlighted to reveal minus sign invoices can be matched manually by clicking on add invoices while adding invoices, filters can be applied for customer , invoice # , due date , and amount range adding invoices sidebar deposit action log the actions associated to each deposit are available by clicking on action log from the deposit details view events shown will include invoice auto matches, approvals, exclusions, errors, re matches, and posting of customer payment to the erp information on who performed each action is also displayed (i e system or user's email address) action log sidebar approve or exclude deposit if matched invoices are fully matched against the deposit amount, the deposit can be approved by clicking the approve match button the match request will then be submitted to netsuite to post the customer payment and apply it to the matched invoices if the invoice is fully paid, it will be marked as paid in full in netsuite the deposit will be moved to the completed tab after being actioned deposit detials viewmatching request submitted if there are no invoices matched against the deposit, clicking exclude deposit will remove the deposit from the list and move it to the completed tab no actions will be taken in netsuite no invoice matched on deposit details viewexclude deposit request submitted deposits history clicking on the history tab reveals all deposit and matching actions done by the system and any users with access to the receivables feature events can be filtered by action date , user , and action type history tab and filters