Long Arrow Right External Link angle-right Search Times Spinner angle-left

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, login 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. 

undefined

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 Month to Date. You can also select from 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. In the example below, I filtered last month's transactions.

undefined

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.

undefined

To remove these, click on the top left corner of the spreadsheet so it highlights everything. 

undefined

Then hover your mouse on the line between A and B column. Youโ€™ll notice that your excel cursor will change into this: ย 

undefined

Double click on the line between A and B column. ย 

undefined

This will bring up the values behind those weird characters as shown below.

undefined

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.)

undefined

If you have any questions, please contact us at support@fitli.com or join live chat on the Fitli site. Enjoy exporting!