How to use FranScape along side book keeping and accounting software.
FranScape has a number of options of simplifying record keeping for customers. The best option to you depends on how your business is structured. You are strongly advised to seek the advice of an Accountant before proceeding.
FranScape is not an accounting system and you should operate a specialist accounts package. Please ask you accountant for information on the right options for you.
Part of FranScape's features is a full and detailed record of every customer's interaction with your business. This includes sales, credits and what amounts are paid by a variety of methods.
Financial accounts are prepared in one of two ways
- Cash accounting
Depending on which basis you use will determine the options you have for extracting data to input into your accounting package.
Amounts received in to your bank are after Transaction Fees. You will need your FranScape invoice to reconcile these. These are emailed to you, if you require a copy please contact Support.
This is the most common way Franchisees account for their sales when using FranScape.
FranScape keeps full customer financial records but does not keep accounting records. To ensure the correct cash accounting records reach your accounting package you have following broad options:
- Connect you Bank Account(s) to your accounting platform marking income as Sales as appropriate.
- Export transactions from FranScape using the Transaction Totals Report and import via CSV.
If you are using the Accruals basis for accounting, options 1 will not be appropriate.
You can still use Option 2 and export transactions for any given date range via CSV into your accounting package using the steps above
Please be aware this will give you line by line transactions per customers whereas your bank may receive income from Stripe in batches.
To Export transactions in FranScape:
- Click on 'Reports' on the left hand pane
- Select 'Transactions Totals'
- Choose the Date Range your require i.e. 1st January 2020 to 31st January 2020 - the system will recall all data held
- Choose the correct Franchisee
- There are 4 transaction types to report on, you can report all 4 at once:
- Charge - when a customer has been charged for a service (i.e. invoiced - regardless of if they have paid)
- Credit - a list of credit applied by customer
- Refund - a list of refunds made by customer
- Payment - a list of payments made, monies received regardless of method, by customer - for a break down of non Stripe payments please chose the Non Stripe Payments report
- There is an export button to CSV at the bottom of the page once the report has been run - this file can then be uploaded into any major accounting page.