So how much time will you save using Fabio!? With 50 typical expense records, in an arbitrary spreadsheet, we transcribed them interactively into FreeAgent (left window). While, in the right window, we reformatted the sheet for Fabio and uploaded with a single click. Regardless of file size, conversion takes about 2 mins of your time, then 1 second per record for Fabio to upload. For just 50 expenses, interactive input took nearly 25 mins. Imagine if you had 200 records to input!? 1hr 40 mins vs 2 mins of your time when using Fabio!
ps. We used all the keyboard shortcuts we knew of for interactive input – tabbing between cells, keyboard selection in drop-down menus, etc. We weren’t trying to be deliberately slow! Even the odd typo, then corrected, was real.
If you’re in an Accounting Practice, and use FreeAgent’s Practice Dashboard functionality, then we have something in the pipeline that’ll interest you. “Fabio Pro”, enabled through an “ACCOUNTANCY” subscription, allows you to manage the records for all your clients in a FreeAgent Practice. Just like a “BUSINESS” subscription, but for any client. No restrictions. We’ll be starting Beta Testing with selected users soon…
Fabio2 is now live, for both new and established Fabio users. It’s 10x more capable than 2015’s Fabio! It’s hard to believe, but the original Fabio could only do one thing – add Expenses to FreeAgent. No bulk download. No deleting. No Invoices, Timeslips, Bills or anything else. Please let us know how you get on.
Now that Fabio2 is getting big and powerful, just like Chewbacca, we found we could really use a couple of Excel macros to comment out, and uncomment, sections of Fabio data files with a click. With the power of the Internet, and a little magic, we developed these:
Sub Fabio2CommentOut()'' Fabio2CommentOut Macro'' Keyboard Shortcut: Ctrl+k' Dim myCell As Range For Each myCell In Selection If Not IsEmpty(myCell) Then _ myCell = "%%" & myCell Next myCellEnd SubSub Fabio2Uncomment()'' Fabio2Uncomment Macro'' Keyboard Shortcut: Ctrl+l' Dim myCell As Range For Each myCell In Selection If Left(myCell, 2) = "%%" Then _ myCell = Right(myCell, Len(myCell) - 2) Next myCellEnd Sub
Ok, so development is progressing well on Fabio2. We now have Closed Group Beta Testing in progress, with selected subscribers, while we work on the final phase.
Progress indicator …which might not seem like a big deal, but from a usability point of view, it provides real-time feedback of progress while chomping through data files, rather than leaving you “hoping” everything is still progressing. We like it a lot!