{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Points of Note","Claim Methods (Foreign Exp)","SGD_Expenses","Foreign_Expenses","Validation (Dropdown)"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Points of Note","index":0,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"**The forms in this excel spreadsheet is only for Non-Expensify users. Expensify users need not use this at all"]
[null,"**Kindly enable Macro (when prompted upon opening this excel) in order to use the forms"]
[]
[null,"Documentation"]
[null,"• If booking airfare by yourself (After confirming with HR to do so),  kindly include quotation that HR provided as an attachment in Synergix staff claims"]
[null,"• Kindly arrange expenditures in ascending order by date (First day of trip to last day)"]
[null,"• For large number of receipts, kindly compile them into just a few documents instead of adding an abundance of attachments. There are tools such as ilovepdf.com that can assist with turning file types into PDF or merging the documents together for free"]
[null,"• Kindly note the difference between credit card slips and invoice/receipts:\nInvoice/receipt: This is what can support your expenses, shows what is bought and the amount\nCredit card slips: Just payment slips that shows transaction is paid, does not include breakdowns of what is bought."]
[null,"Key-In to Synergix"]
[null,"• If you used this excel, only need to key a maximum of 3 lines (categories) into Synergix software for Staff Claims"]
[null,"• Intranet has a guide on how to raise claim in the Synergix system, should you need to familiarise yourself"]
[]
[null,"Claimability"]
[null,"• Kindly note about the daily subsistence rate provided by HR Team via email"]
[null,"• Meal claim should generally not cost more than SGD50 per head, per meal"]
[null,"• For business entertaining requests (Non-Director level), kindly discuss plans with Chief Operating Officer before expendiure is incurred"]
[null,"• Private expenses are strictly not allowed"]
[null,"Others"]
[null,"• If difficulties are met when using the form, kindly reach out to HR Team or Finance Team"]
[null,"• Kindly go through Expense Reimbursement Policy (Sent by HR Team) thoroughly prior to going for your trip"]
[null,"• When in any form of doubt about claimability, always check in with HR Team before proceeding"]

{"sheet":"Claim Methods (Foreign Exp)","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The above is an extract from the Expenses Reimbursement Policy (within CARES Financial Policy), for more information kindly refer to the policy."]
[]
[null,"Method #2 is the most convenient, assuming that you don't mind exchange differences and not getting back the exact sum paid out from your bank [Since no separate screenshot of daily OANDA rates (Method #1) or credit card statement (Method #3) is required]. \nFor Method#2, all you need to do is submit 1 claim in SGD for SGD expenses, and then open another 1 claim in foreign currency expenses (that uses system rate)."]

{"sheet":"SGD_Expenses","index":2,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Exp Currency:","SGD"]
[]
[null,"Date","Type","Sub-Type","Description / Purpose","Amount (SGD)","From","To"]
[null,"A. Flight & Accomodation"]
[]
[]
[]
[]
[]
[]
[null,"B. Transportation"]
[]
[]
[]
[]
[]
[]
[null,"C. Food / Other Expenses"]
[]
[]
[]
[]
[]
[null,null,null,null,"Total (SGD) ",{"$f":"SUM(F6:F26)","v":0}]

{"sheet":"Foreign_Expenses","index":3,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,9,4,10],[1,12,4,13]]}
[]
[null,null,null,null,null,null,null,null,null,"Only use this if claiming \nOANDA rate conversion. Include all rate screenshots as attachments",null,null,"Only use this if claiming \ncredit card SGD amounts. Include statement screenshots as attachments"]
[]
[null,"Exp Currency:"]
[]
[null,"Date","Type","Sub-Type","Description / Purpose",{"$f":"\"Amount (\"&$C$4&\")\"","v":"Amount ()"},"From","To"]
[null,"A. Flight & Accomodation",null,null,null,null,null,null,null,"Rate","Amount (SGD)",null,null,"Amount (SGD)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(F8*J8,2),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(F9*J9,2),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(F10*J10,2),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(F11*J11,2),0)","v":0}]
[]
[]
[null,"B. Transportation"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(F15*J15,2),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(F18*J18,2),0)","v":0}]
[]
[]
[null,"C. Food / Other Expenses"]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,{"$f":"\"Total (\"&$C$4&\") \"","v":"Total () "},{"$f":"SUM(F6:F26)","v":0},null,null,null,"Total (SGD) ",{"$f":"SUM(K6:K26)","v":0},null,"Total (SGD) ",{"$f":"SUM(N6:N26)","v":0}]

{"sheet":"Validation (Dropdown)","index":4,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Type","Flight","Accomodation","Transport","Food","Misc"]
[null,null,null,"Flight","Flight","Accomodation","Bus","Breakfast","Others"]
[null,null,null,"Accomodation",null,null,"Coach","Lunch"]
[null,null,null,"Transport",null,null,"Train","Dinner"]
[null,null,null,"Food",null,null,"Taxi","Snack"]
[null,null,null,"Misc",null,null,"MRT","Groceries"]
[null,null,null,null,null,null,null,"Others"]