Exporting your Sales, Booking or Account Balances report and seeing weird characters?
Exporting your Sales Report will give you more details about your Sales and the specifics (date and time, how clients paid, gross vs. net dollar amount, service fees, full/partial refund, etc).
To do this, log in to your Fitli business account. Then, click Reports at the top menu. In the example below, we'll export the "Sales Report By Transaction" data.
Use the pulldowns at the top to filter out the needed data. You can view sales by "All Transaction Types", "All Funding Sources" or Payment Methods (card, cash, check, etc etc). Use the pulldown for the time frame. It's default to "Today". You can also select from Month to Date, Last Month, Year to Date, or do a custom search by selecting the date range or click View All to pull-up the current report. Use the keyword box to enter your client's name, email address, item or promo. You can use any one of these tabs or do a combination search and then hit Search. When done, click Export on the right side.
The .csv file will be automatically downloaded. You probably wondered, why is the exported file showing some weird characters like “#####” on select rows/columns/cells? That is because it’s a .csv file and it's not formatted yet.
To remove these, click on the top left corner of the spreadsheet so it highlights everything.
Then hover your mouse on the line between A and B column. You’ll notice that your excel cursor will change into this:
Double click on the line between A and B column.
This will bring up the values behind those weird characters as shown below.
The .csv file can be opened in many types of apps but usually, it's default to be opened in excel. You can use the "Save As" option on Excel to save it to your desired file format (PDF, txt, word, etc). In case you don't have Excel, you can copy the data from the .csv file and paste it to a Google Spreadsheet. You can use the filter function of your favorite spreadsheet program to filter the data you need.
That's about it! Any questions? Chat with us or send us an email to support@fitli.com.
Related Articles
Can I search my Sales Report, or sort the data in any way?
We know the Sales Report is your most important spot to see, in real time, how much money you're making, which clients are purchasing and what they're buying, and be able to search for specific information to help your business. You can check your ...Bookings Report!
More about Bookings Report! Sections: The Bookings Report has 2 sections: Bookings Report By Transaction and By Service. Bookings Report By Transaction Bookings Report By Service Search Box, Pulldowns and Pagination: You can search/filter by using ...Importing, exporting and Customer List Questions?
So you've just signed up as a new business with Fitli and need to import your customers - or you're an existing business and want to obtain your customer list - how do you do that? It's easy! Here's how. Exporting your Customer List FROM Fitli: Log ...Understanding your Disbursement Report
The Disbursement Report summarizes the amount of funds that will be deposited to your account on each day and shows all the transactions that are part of that disbursement. This report will show Card and/or ACH disbursements (if you accept ACH ...Edit or change Purchase Notes on the Sales Report
If you're using the "Notes" section of the purchase process to record notes for your client transactions (check numbers, tracking cash purchases, or need to update when a client paid), you can edit the notes on the Sales Report. First, head to the ...