Posted by Pulkit on Upwork on Oct 14, 2021
We use Xero to reconcile bank transactions, we also want to create excel reports from that data that show us some business analytics. To Succeed in this role you need:
- Strong excel skills: Know how to use Pivot tables and advanced excel formulas
- Knowledge of Singapore accounting and how to reconcile transactions for a Singapore Business
This job entails:
- One time going through and fixing past reconciled data e.g. tax rate on past reconciliation is not correct
- On a weekly basis you will need to reconcile new transactions.
- On a monthly basis you will need to update the excel sheet with new data to show business metrics
Project Type: Complex project
You will be asked to answer the following questions when submitting a proposal:
- Have you used Xero before?
- Have you done accounting for a Singapore-based business before?
- Do you know how to create pivot tables in Excel?
- Do you know how to use the following functions in excel INDEX(), MATCH(), FILTER(), TRANSPOSE()
Skills and Expertise
- Bank Reconciliation
- Language: English
- Preferred Location: India, Philippines
- Hourly: Less than 30 hrs/week
- Project Length: More than 6 months
- Level of expertise: Intermediate level - I am looking for a mix of experience and value
- [input description here]
- The role is a remote role for all countries worldwide.
- Hourly Rate: $5.00-$10.00
Fill out the application form above
- Initial application (1-2 minutes)
- Short call (15-30 minutes)
- Long project (up to 1 week)
- Long call (30-45 minutes)
- Final decision