Financial Interface with Sage 50 For incorporated Physician Societies
Financial Interface FEMS Sage 50 • Physician Claim: $ 150.20 • Physician Claim: $ 150.20 • Director Claim: $ 135.20 (paid VersaPay) 1 Claims • Director Claim: $ 150.20 $ 15.00 Income taxes (paid by cheque) CPP (PS pays Gov.) $ 5.00 Total: $ 155.20 • Parking Expense: $ 12.50 • Parking Expense: $ 12.50 2 Expenses (paid VersaPay) • Catering Service: $ 170.75 • Catering Service: $ 170.75 3 Supplier Claims (paid by cheque) • Office Rent: $ 1300.00 Internal Operating 4 Expenses (paid by cheque or PS credit card) Difference between FEMS $ 1305.00 and Sage 50:
Extract Physician Claim Generate Extract in Import Extract into 1 2 Expense FEMS SAGE 50 Supplier Claim Payment Requests in FEMS Pending Physician Claim VersaPay: $150.20 FEMS Pending Director Claim (Dr. JOHN) Cheque: $150.20 REGROUP Pending Director Claim (Dr. JOHN) Cheque: $300.40 Manage Manual Payments 3 Pending Director Claim (Dr. JOHN) Cheque: $450.60 Payments Pending Expense VersaPay: $12.50 Pending Supplier (MOLLY Catering) Cheque: $170.75 REGROUP Payments Pending Supplier (MOLLY Catering) Cheque: $512.00
Payment Requisition REPORT in FEMS Physician Claim VersaPay: $150.20 FEMS Director Claim (Dr. JOHN) Cheque: $150.20 Payment Cheque: $300.40 Request Manual Payments 4 RTXC56 Requisition Report Cheque: $450.60 Expense VersaPay: $12.50 Payment Supplier (MOLLY Catering) Cheque: $170.75 Request L WPO57 Cheque: $512.00 Payroll in SAGE 50 SAGE 50 Director Claim (Dr. JOHN) Cheque: $150.20 REQUIRED Director Claim (Dr. JOHN) Cheque: $300.40 DEDUCTIONS : 5 Income tax & CPP Run Payroll in SAGE 50 Director Claim (Dr. JOHN) Cheque: $450.60 Director Claim (Dr. PAUL) Cheque: $300.40 REQUIRED DEDUCTIONS : Income tax & CPP Director Claim (Dr. PAUL) Cheque: $150.20
Mark Manual Payments PAID in FEMS Processing Paid Director Claim (Dr. JOHN) Cheque: $300.40 Paid Processing Director Claim (Dr. JOHN) Cheque: $150.20 FEMS Processing Paid Director Claim (Dr. JOHN) Cheque: $300.40 Mark Manual Paid Processing 6 Director Claim (Dr. FOX) Cheque: $450.60 Payments Paid Processing Paid Director Claim (Dr. FOX) Cheque: $150.20 Paid Processing Supplier (MOLLY Catering) Cheque: $170.75 Processing Paid Supplier (MOLLY Catering) Cheque: $512.00 FEMS Run Income 7 Statement
SAGE 50 Process Internal 8 Operating Expenses 9 Run Financial Statement SAGE 50 FEMS Create IOE $ 2120.00 10 Transaction in FEMS
Financial Interface Part I SAGE 50 (SAGE) FEMS Generate Extract 1 2 Import Extract into SAGE 3 Manage Manual Payments Manual Payments 4 Requisition Report 5 Run Payroll in SAGE 6 Mark Manual Payments Paid 7 Run Income Statement Process Internal 8 Operating Expenses Run Financial Statement 9 in SAGE Create IOE Transaction 10
Generate Extract Extract FEMS FEMS . . Physician Claim Expense SupplierClaim
Generate Extract • identifies finance entries not previously extracted for the specified physician society • creates the export file in the appropriate format: QuickBooks or Sage 50 Button to generate new extract History of previous extracts generated with pertinent details
Generate Extract The * End Date must be less than today's date. You may typically want to select an end-of-week, mid-month or end-of-month date. NOTE: this date must match the E nd Date of the Generate Manual Payments Request.
Generate Extract New Extract Generated is now available to you in the updated list of extracts Download the extract file NOTE: These finance transactions Undo button unmarks must not have been uploaded and previously extracted finance applied to the PS’s accounting system entries for this specific extract
Import into SAGE 50 Extract Physician Claim SAGE 50 SAGE 50 Expense $ SupplierClaim VISA 4550 3345 6787 9012 John Smith
For Sage 50: the extract file is a zip file VGHPS_20170216_ExtractNumber_FE-000036.zip 1. Extract the text files from within the zip file 2. Each text file needs to be imported (one for each transaction date) VGHPS_20170208_ExtractNumber_FE-000036.txt VGHPS_20170207_ExtractNumber_FE-000036.txt
Click Switch to Enhanced View Check your Session Date is changed so that it reflects the accounting date you desire
Complete the steps in the Import Transactions Wizard as follows
Complete the steps in the Import Transactions Wizard as follows
Complete the above import task for each extract .txt file
Payment Requests in FEMS Pending Physician Claim VersaPay: $150.20 Pending Director Claim (Dr. JOHN) Cheque: $150.20 REGROUP Pending Director Claim (Dr. JOHN) Cheque: $300.40 Payments Pending Director Claim (Dr. JOHN) Cheque: $450.60 Pending Expense VersaPay: $12.50 Pending Supplier (MOLLY Catering) Cheque: $170.75 REGROUP Payments Pending Supplier (MOLLY Catering) Cheque: $512.00 Manage Manual Payments in FEMS Payment Requests in FEMS Processing Physician Claim VersaPay: $150.20 Processing Director Claim (Dr. JOHN) Cheque: $150.20 ONE Processing Cheque: $300.40 Payment Processing Cheque: $450.60 Processing Expense VersaPay: $12.50 Processing Supplier (MOLLY Catering) Cheque: $170.75 ONE Payment Processing Cheque: $512.00
Manage Manual Payments
Manage Manual Payments
Manage Manual Payments
Manage Manual Payments Click on Proceed to generates the cheque requests
Manage Manual Payments
Payment Requisition REPORT in FEMS Physician Claim VersaPay: $150.20 Director Claim (Dr. JOHN) Cheque: $150.20 Manual Payments Payment Cheque: $300.40 Request RTXC56 Requisition Report Cheque: $450.60 Expense VersaPay: $12.50 in FEMS Payment Supplier (MOLLY Catering) Cheque: $170.75 Request L WPO57 Cheque: $512.00
Manual Payments Requisition Report
Manual Payments Requisition Report
Run Payroll in SAGE 50 1 Payroll in SAGE 50 2 Director Claim (Dr. JOHN) Cheque: $150.20 SAGE 50 SAGE 50 REQUIRED Director Claim (Dr. JOHN) Cheque: $300.40 DEDUCTIONS : Income tax & CPP Director Claim (Dr. JOHN) Cheque: $450.60 3 $ Director Claim (Dr. PAUL) Cheque: $300.40 REQUIRED VISA 4550 3345 6787 9012 DEDUCTIONS : John Smith 4 Income tax & CPP Director Claim (Dr. PAUL) Cheque: $150.20
Mark Manual Payments PAID in FEMS Processing Paid Director Claim (Dr. JOHN) Cheque: $300.40 Processing Paid Director Claim (Dr. JOHN) Cheque: $150.20 Mark Manual Processing Paid Director Claim (Dr. JOHN) Cheque: $300.40 Payments Paid Processing Paid Director Claim (Dr. FOX) Cheque: $450.60 in FEMS Processing Paid Cheque: $150.20 Director Claim (Dr. FOX) Processing Paid Supplier (MOLLY Catering) Cheque: $170.75 Paid Processing Supplier (MOLLY Catering) Cheque: $512.00
Mark Manual Payments Paid
With the Manual Payments Requisition Mark Manual Payments Paid Report used to write the cheques, find the corresponding cheque request and click the button Mark Paid
Mark Manual Payments Paid • Specify the cheque number used to settle this cheque payment request (marked 1 in the diagram). • Specify the Payment Date (marked 2). This defaults to today’s date but can be back- dated. Forward-dating is not supported. • Add any additional comments (marked 3) • Click the button Mark Paid (marked 4) Once this step has completed, the cheque requisition status is updated to Paid
The detail of the cheque payment can be Mark Manual Payments Paid seen by removing the default filter restriction and then clicking on the line item of interest for the member cheque payment just marked as completed
Mark Manual Payments Paid
Run Income Statement Income Statement FEMS FEMS . . Member Time $ 1400 Salaries & wages $ 750 Meeting Expenses $ 260 Meals $ 920
FEMS Run Income Statement 41,209.30 41,209.30
Run Financial Statement in SAGE 50 Income Statement SAGE 50 SAGE 50 Member Time $ 1400 Salaries & wages $ 750 $ VISA Meeting Expenses $ 260 4550 3345 6787 9012 John Smith Meals $ 920 Office Rent $ 2120
SAGE 50 Run Financial Statement CPP Expense $ 337.33 Office Expenses $ 17,600.54 Banking Fees $ 29.97 Profess. Fees $ 2,636.81 Total of IOE $ 20,604.65
Create an IOE Transaction in FEMS SAGE 50 FEMS FEMS $41,209.30 SAGE $60,256.84 Total of IOE in SAGE 50: $ 20,604.65
Create an IOE Transaction
Create an IOE Transaction 20,604.65
Financial Interface Part II FEMS Sage 50 11 Generate Extract Import Extract into 12 Sage 50 Run Financial 13 Statement in Sage 50 Run Income 14 Statement Compare FEMS Income Statement with the Financial Statement in Sage 50: they will balance
Contact FEMS Support femssupport@doctorsofbc.ca 604-638-4869 or 1-800-665-2262 www.fems.facilityengagement.ca
Recommend
More recommend
