• RBC visa transactions are integrated with the Concur expense reporting module.
• RBC visa entries show in Concur as payment method "RBC Corporate Card".
• Visa expenses are submitted via Concur Expense Report. 
• Accounts payable pulls batches of submitted and approved expense reports to NetSuite.  
• When processed by AP visa expenses show in NetSuite as an invoice payable to vendor "RBC Visa Business Account".
• Multiple Visa expense line items submitted on one expense claim will automatically generate ONE invoice in NetSuite payable to RBC Credit Card. 
• If there are regular expenses (payable to the employee) AND visa expenses on one claim, then TWO invoices will be generated in NetSuite

Concur integration automatically creates an invoice payable to “RBC Visa Business Account”

The payable created has no designation associated as compared to the expense line items so the PyanGo script will automatically fire to create the correct accounts payable designations on each invoice. (See sample entries #1-3 below which shows the submissions made by a Visa Cardholder throughout a month). When the invoice is entered, the Expenses will be coded directly to the project and will appear on the project Income Statement; when the PyanGo script fires to allocate the Accounts Payable amount to the project, this will show as a liability on the project Balance Sheet.

EXAMPLE - RBC EXPENSE INVOICE IN NETSUITE

GL IMPACT - RBC Expenses Invoice

Next, A/P will process any open RBC invoices as per a weekly schedule. These invoices will be “paid” using a clearing account. (See sample entry #4 below which shows the invoice payment). There will be two clearing accounts, one for The Foundation and one for The Society which will be reconciled with the actual statement when it is received and paid. Once the invoice is “paid” using the clearing account, the impact to the Project will change to “Due to / from Cash” rather than “Accounts Payable”.

When the The Foundation and The Society RBC Statements arrive at month end, A/P will process a payment to RBC for the total statement amount, which may exceed the amount of the expenses submitted by Users. This payment will be paid from the Vancity bank account, and be “expenses” to the clearing account to offset the transactions from week 1-3. (See sample entry #5 below which shows the actual payment of the statement balance coming out of the bank account and off-setting the clearing account).