Home Creators Posts Import Register Favorites Logout

Content

Hello Members,

The training we have for this week that I have shared with you was about the Mini Accounting Application. If you have not seen it yet, you can view it right here on YouTube.

Now that the training has been released, I am looking for your feedback to make this even better, just for you, our incredible Patreon Members.

So, what Feature can I add for you? Did you find an issue you want me to fix? Or is there a particular area you would like me to focus on?

Please comment your ideas and feedback to any of these below and I will do my best to not only create an updated workbook but release a private training video next Monday, right here on Patreon.

I am looking forward to hearing from you and thanks so much for your support.

Regards,

Randy

Files

Learn How To Make Your Own Accounting Application In Excel Today - Full Masterclass

🔥 GET 250 OF MY BEST TEMPLATES WITH PDF VBA CODEBOOKS HERE► https://bit.ly/250WKBK-Desc 📢JOIN US ON PATREON FOR UNRELEASED TRAININGS + MORE ► https://bit.ly/PatreonDesc 👉JOIN MY MENTORSHIP PROGRAM - EARN PASSIVE INCOME► http://bit.ly/MentorProgram_YTDesc 👨‍💼JOIN MY INCREDIBLE DASHBOARD MASTERCLASS HERE► http://bit.ly/Dashboard_YTDesc 📣LEARN VBA FROM THE GROUND UP ► https://bit.ly/VBACourse_Discount In this week’s training, I will show you how to [single line video description] 📣30-HOUR VBA COURSE► https://bit.ly/VBACourse_Discount ⬇DOWNLOAD THIS WEEKS WORKBOOK FREE: 📩 USING YOUR EMAIL: http://bit.ly/MiniAcct_WkbkDl 💬 FACEBOOK MESSENGER: http://bit.ly/MiniAcct_FbDld EXCEL COURSES: ►DASHBOARD MASTERCLASS: http://bit.ly/Dashboard_YTDesc ►MENTORSHIP PROGRAM: http://bit.ly/MentorProgram_YTDesc ►BEGINNERS VBA COURSE: https://bit.ly/FreeVBACourse EXCEL PRODUCTS: ►The Ultimate Excel Resource Guide: http://bit.ly/UERG_YTDesc ►250 Excel Workbooks: https://bit.ly/250WKBK-Desc ►Convert Excel Into A Secure EXE File: http://bit.ly/SecureExcel ►Automate Your VBA Programming: https://bit.ly/AutoMacroAddIn ►Create Dashboards & Charts in Seconds: https://bit.ly/Pine-Bi ►Find the Best Excel Products & Courses Here: http://bit.ly/ExcelProducts Timestamps: 0:00 - Introduction 0:38 - Overview 41:55 - New Item 44:55 - Save and Update Item 48:18 - Update Sorted Names 50:08 - Saved Message Item 51:02 - Browse Item Picture 55:26 - Clear Item Picture 56:22 - Show Item Picture 59:48 - Load Item 1:02:01 - Delete Item 1:16:07 - Load List Transaction 1:20:07 - Change Event 1:20:24 - Selection Change Event 1:21:11 - Clear Filter Transaction 1:21:21 - New Transaction 1:23:16 - Save and Update Transaction 1:25:41 - Load Transaction 1:26:03 - Delete Transaction 1:26:50 - Add Edit Name 1:31:40 - Click Save Button 1:54:57 - Change Event 2:12:21 - Add Edit Name Orders 2:16:33 - Add New Menu Order 2:18:04 - Save and Update Order 2:24:57 - New Order 2:45:26 - Copy to Order 2:49:18 - Load Order 2:55:20 - Email Order 2:58:54 - Delete Order 3:07:50 - Refresh Dashboard JOIN OUR COMMUNITY: ►Facebook Group: http://bit.ly/groupexcel ►Facebook Fan Page: https://bit.ly/EFF_FanPage Follow me on my Social Media Accounts: 🐦Twitter: https://twitter.com/Excel4Freelance 🌏Website: https://www.ExcelForFreelancers.com 🔗LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ 👤Facebook: https://www.facebook.com/ExcelForFreelancers/ 📸 Instagram: https://www.instagram.com/excelforfreelancers/ 🎥Rumble: https://rumble.com/c/ExcelForFreelancers 👤Locals: https://locals.com/member/ExcelFreelancers ✉Telegram: https://t.me/ExcelForFreelancers 📲Gab: https://gab.com/ExcelForFreelancers About Us: I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money. I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep these training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams. Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here: 👉 https://www.youtube.com/c/ExcelForFreelancers/ New Training Video Uploaded every Tuesday! Thank you very much for your continued support, Randy Austin #accounting #accountingapp #exceltraining

Comments

Duane Hargrave

Love your lessons...is there a way that you could incorporate multi pay types, such as a credit card payment and cash...or accept a gift certificate and balance in cash where it would record and reconcile as separate items...?

Duane Hargrave

I'm sorry, I didn't mean to accept outside payments system payments I meant to be able to track payments within the actual workbook. Like with a POS system, there are several times that a person wants to pay with a certain amount in cash, and pay a balance with another method (like a debit card or perhaps a gift certificate). Another possible instance could be requiring a down payment on a order with balance due upon completion of the work. The down payment could be via credit card, and when the job is done they want to pay balance in cash. Lets say the deposit was paid on the 10th of the month, and the balance is paid on the 15th. It also would allow for the ability to account for payments that were returned unpaid, like a bounced check (rare payment form nowadays), but still hapoens. I hope this explains a little more. This would also show percentage of how people pay with certain types of currency.

Excel For Freelancers

Hi Duane, thanks for the additional details. I do understand and I have a dedicated training on that called the 'Accounts Receivable Manager' which covers a lot of what you are requesting here: https://youtu.be/AQF300aevfY (It is also here on Patreon as well) I hope this helps and thanks so much.

Henk van der Werk

Many small businesses don't only sell products, also hours. How can i implement also "billing by the hour" in the mini accounting application?

Excel For Freelancers

Hi and thanks. Great question. The Mini Accounting Application has two types of items 'Inventory' and 'Non-Inventory'. For hourly billing you can use the non-inventory items, and create unlimited # of those which can be used for hourly billing. If you take a look at the template I have created, and look at the last item, called 'Hourly Service Work', this is a perfect example of an item that is used to bill by the hour. I hope this helps and thanks so much.

Anni Birgit Sommer

if I want it to be able to be used by several users and therefore upload the file to Onedrive, you can not click on shapes to run a macro. How to solve that problem?

Excel For Freelancers

Hi and thanks, the best way to solve this problem is to duplicate the workbook and give it to each user. You would then share ONLY the data between the workbooks in a shared drive such as OneDrive, Dropbox or Google Drive. I show you exactly how to do this in this video https://youtu.be/aKV5seZmiBs