Upload bank transactions to Xero via App – 18/02/2023 11:51 EST
Project detail
I am creating a Xero Accounting web based application for the Xero Marketplace.
Deadline for Deliver is end of February 2023.
Once subscribed, the user will be able to email or save their bank statements to a set location and the App would then convert the bank statements to the correct Xero format and be posted to Xero through the back end,
The App must allow the user to select their bank account as the CSV formats have different layouts for the different banks.
I have been trying to build this myself but have run short of time to complete it.
I have subscribers ready to apply this immediately.
The right person to help me complete this project must have Xero Developer access and experience in building subscription based apps.
Non Disclosure and IP agreement will be mandatory.
Process flows as follows :
Subscription :
User to subscribe and agree to payment terms (Pay-fast or alternative)(month to month)
Approve app access. (Standard)
If no payment suspend app and point to payment option. (Standard)
If lapse in payment suspend service and access – point to payment options. (Standard)
App flow.
1st time setup:
OAuth2 access to Xero account. ( create link)
Select Country
Select Bank ( This will determine workflow for csv conversion)
Select Bank account type
Enter Bank account Details (Account number , Branch number, name)
Match to bank account in Xero chart of accounts.
generate personalized email address to be copied to transfer file.
On receipt of email or file via email :
OAuth2 access to Xero account. ( create link)
Transform csv to Xero Bank statement template.
Post statement to Xero.
Notify user of successful upload.
If Unsuccessful, notify user to re-post or edit banking details in app.
Each bank will require a different WIP to format data to Xero Bank statement template.(I require 3 for this project)