Re-posting this job - 12 months accounts reconciliation
- or -
Post a project like this£200(approx. $251)
- Posted:
- Proposals: 32
- Remote
- #4134775
- OPPORTUNITY
- Expired
Data entry specialist, financial account specialist, french content proof reader
Antananarivo
WordPress Expert/Woocommerce Expert/Data Scientist/Python Expert/Auto-CAD/3D/2D Animation/ White Board Animation
Rawalpindi
1087704520827022076875332725713796601351076720554294853109613151005108825152753154
Description
Experience Level: Expert
Hi.
What am I looking for? - I need 12 months of transactions reconciling. This includes validating the line items on the bank account statement, reconciling debit and credit card receipts, checking customer payments against invoices, and checking for duplicate payments and any payments we made to suppliers.
What do you need to give me at the end? A spreadsheet in Excel format listing every transaction, its reconciliation status - reconciled and a reference to the supporting evidence; and where it doesn't reconcile, mark it as Query and add a note with what the problem is, i.e not on bank statement/duplicate etc.
By when? - 17:00 GMT London, Saturday, 30 December 2023.
Who are you? - An experienced bookkeeper/accountant who can use Excel and knows how to make it work for you with functions like VLOOKUP(). Don't consider this proposal if you plan on doing this manually line by line. Preferably, you'll also know Xero, as we're looking for someone to help us get that in order - subject to a new proposal through PPH.
Context - The business has implemented Xero; however, the staff have been doing their own thing and using multiple sources to raise invoices, track payments made/received, etc. They have not reconciled their transactions. The result is the closing balance cannot be relied on. They trade in GBP and USD with the odd Euro transaction in there, less than 10 in the year. The conversion rate from USD to GBP was set at the start of each month and changed on the 1st of the following month.
Spreadsheets available - Exchange rates from GBP to USD, balance summary, itemised balance change from activity, itemised payout reconciliation, bank account transactions, sales invoice tracker, supplier invoices paid or owing, outstanding payments schedule and Stripe transactions spreadsheet.
Other - I expect you will have questions and possibly need further information. So, this will probably take a few iterations, which is okay with me, and I will be available. It's more important we get it right, state any assumptions made in the notes and identify any variances.
What am I looking for? - I need 12 months of transactions reconciling. This includes validating the line items on the bank account statement, reconciling debit and credit card receipts, checking customer payments against invoices, and checking for duplicate payments and any payments we made to suppliers.
What do you need to give me at the end? A spreadsheet in Excel format listing every transaction, its reconciliation status - reconciled and a reference to the supporting evidence; and where it doesn't reconcile, mark it as Query and add a note with what the problem is, i.e not on bank statement/duplicate etc.
By when? - 17:00 GMT London, Saturday, 30 December 2023.
Who are you? - An experienced bookkeeper/accountant who can use Excel and knows how to make it work for you with functions like VLOOKUP(). Don't consider this proposal if you plan on doing this manually line by line. Preferably, you'll also know Xero, as we're looking for someone to help us get that in order - subject to a new proposal through PPH.
Context - The business has implemented Xero; however, the staff have been doing their own thing and using multiple sources to raise invoices, track payments made/received, etc. They have not reconciled their transactions. The result is the closing balance cannot be relied on. They trade in GBP and USD with the odd Euro transaction in there, less than 10 in the year. The conversion rate from USD to GBP was set at the start of each month and changed on the 1st of the following month.
Spreadsheets available - Exchange rates from GBP to USD, balance summary, itemised balance change from activity, itemised payout reconciliation, bank account transactions, sales invoice tracker, supplier invoices paid or owing, outstanding payments schedule and Stripe transactions spreadsheet.
Other - I expect you will have questions and possibly need further information. So, this will probably take a few iterations, which is okay with me, and I will be available. It's more important we get it right, state any assumptions made in the notes and identify any variances.
Lee H.
100% (33)Projects Completed
32
Freelancers worked with
17
Projects awarded
28%
Last project
19 Nov 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
How many transactions approximately need reconciling?
Lee H.28 Dec 2023Hi Tracy. Around 1600 on the Stripe account. This doesn't include the AP account which is considerably less.
1083923
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies