- 139
- 76 726
Theaccountantguy
India
เข้าร่วมเมื่อ 26 ต.ค. 2022
Chartered Accountant building systems in Notion for Business and Personal needs.
Download Templates Here 👉 : theaccountantguy.gumroad.com/
For business queries/collab/affiliate opportunities 📧 - notionformyuse@gmail.com
Download Templates Here 👉 : theaccountantguy.gumroad.com/
For business queries/collab/affiliate opportunities 📧 - notionformyuse@gmail.com
Wizzygen Full Walkthrough Video | How to create AI Generated Content in @Notion
In this video, we take a quick walkthrough of using Wizzygen, an AI-content generator SaaS platform that helps you generate AI content with ease onto your @Notion workspace.
This generates content both on your Notion Pages and Notion Databases.
Wizzygen Link - www.wizzygen.com/
How to start using Wizzygen?
1. Simply head over to the wizzygen platform, signup to create an account and start generating ai content onto your notion workspace.
2. This requires use of of your own API Key which is stored in local storage of your browser during the run time. Thus the API Key provided is not stored anywhere in cloud storage or any other external storage.
3. Connect your notion workspace with Wizzygen through private integration key and start using Wizzygen to generate AI content.
Note: Every new user registered will get 10 FREE AI prompts to start with 😀
#notion #ai #gemini #openai #saas #artificialintelligence #content #contentcreation #socialmedia #tutorial #notionapp #notiontutorial #wizzygen #software #contentgenerator #contentgeneration
This generates content both on your Notion Pages and Notion Databases.
Wizzygen Link - www.wizzygen.com/
How to start using Wizzygen?
1. Simply head over to the wizzygen platform, signup to create an account and start generating ai content onto your notion workspace.
2. This requires use of of your own API Key which is stored in local storage of your browser during the run time. Thus the API Key provided is not stored anywhere in cloud storage or any other external storage.
3. Connect your notion workspace with Wizzygen through private integration key and start using Wizzygen to generate AI content.
Note: Every new user registered will get 10 FREE AI prompts to start with 😀
#notion #ai #gemini #openai #saas #artificialintelligence #content #contentcreation #socialmedia #tutorial #notionapp #notiontutorial #wizzygen #software #contentgenerator #contentgeneration
มุมมอง: 53
วีดีโอ
Wizzygen | AI Content Generator for Notion
มุมมอง 5628 วันที่ผ่านมา
In this video, we take a quick walkthrough of using Wizzygen, an AI-content generator SaaS platform that helps you generate AI content with ease onto your @Notion workspace. This generates content both on your Notion Pages and Notion Databases. Wizzygen Link - www.wizzygen.com/ How to start using Wizzygen? 1. Simply head over to the wizzygen platform, signup to create an account and start gener...
Employee Paycheck Tracker | How to keep track of employee payments using @Notion
มุมมอง 1112 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up an employee paycheck tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/employeepaychecktracker FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Templates...
Office Events Planner | How to keep track of office events using @Notion
มุมมอง 242 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a office events tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/officeeventsplanner FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Templates: theacco...
Home Inventory Tracker | How to track home inventory using @Notion
มุมมอง 1542 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a home inventory tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/homeinventorytracker FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Templates: theac...
Customer Payments Tracker | How to set up a customer payments tracker in @Notion
มุมมอง 1183 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a customer payments tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/customerpaymentstracker FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Templates:...
Cashback Rewards Tracker | How to track your cashback rewards using @Notion
มุมมอง 353 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a cashback rewards tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/cashbackrewardstracker FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Templates: t...
Tech Stack Planner | How to use @Notion to maintain your business tech stack
มุมมอง 383 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a tech stack planner and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Business Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/techstackplanner FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Templates: theaccountan...
My Asset Planner | How to plan for your assets using @Notion
มุมมอง 283 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up an asset planner and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Business Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/assetplanner FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Templates: theaccountantguy.gum...
Technology Expenses Tracker | How to keep track of technology expenses using @Notion
มุมมอง 193 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a technology expense tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/technologyexpensestracker FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Templat...
Branding Expenses Tracker | How to keep track of branding expenses using @Notion
มุมมอง 193 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a branding expense tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/brandingexpensestracker FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Templates: ...
Membership Expenses Tracker | How to track membership expenses using @Notion
มุมมอง 183 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a membership expense tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/membershipexpensetracker FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Template...
License Expense Tracker | How to use @Notion to keep track of license and permit expenses
มุมมอง 113 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a license and permit expense tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/licenseandpermitexpensetracker FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: N...
Product Development Expenses Tracker | How to use @Notion to keep track of development expenses
มุมมอง 103 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a product development expense tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/productdevelopmentexpensestracker FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINK...
Shipping Expenses Tracker | How to track shipping expenses in @Notion
มุมมอง 323 หลายเดือนก่อน
In this tutorial video, I have used @Notion to set up a shipping expense tracker and showed you a quick walkthrough on how to build yours. This template is part of a series of Notion Finance Templates that you can find on this channel. TEMPLATE LINK 🔗: theaccountantguy.gumroad.com/l/shippingexpensetracker FOR BUSINESS QUERIES / COLLAB 📧: notionformyuse@gmail.com OTHER LINKS: Notion Templates: t...
Legal Expense Tracker | How to track legal expenses in @Notion
มุมมอง 153 หลายเดือนก่อน
Legal Expense Tracker | How to track legal expenses in @Notion
Commission Expense Tracker | How to keep track of commission expenses using @Notion
มุมมอง 213 หลายเดือนก่อน
Commission Expense Tracker | How to keep track of commission expenses using @Notion
Operating Expenses Tracker | How to track your operating expenses in @Notion
มุมมอง 273 หลายเดือนก่อน
Operating Expenses Tracker | How to track your operating expenses in @Notion
Recruitment Expense Tracker | How to track recruitment expense for business in @Notion
มุมมอง 333 หลายเดือนก่อน
Recruitment Expense Tracker | How to track recruitment expense for business in @Notion
Business Expense Tracker | How to use @Notion to track business expenses
มุมมอง 843 หลายเดือนก่อน
Business Expense Tracker | How to use @Notion to track business expenses
Business Income Tracker | How to track business income in @Notion
มุมมอง 503 หลายเดือนก่อน
Business Income Tracker | How to track business income in @Notion
House Rent Payments Tracker | How to use @Notion to track house rental payments
มุมมอง 1515 หลายเดือนก่อน
House Rent Payments Tracker | How to use @Notion to track house rental payments
Notion Check Writing Template | How to use @Notion to keep track of cheque related payments
มุมมอง 325 หลายเดือนก่อน
Notion Check Writing Template | How to use @Notion to keep track of cheque related payments
Paycheck Budget Tracker | How to budget for your paycheck
มุมมอง 975 หลายเดือนก่อน
Paycheck Budget Tracker | How to budget for your paycheck
Notion Formula Chatbot | How to use Notion Formula Chatbot to get answer to Notion Formula Questions
มุมมอง 4236 หลายเดือนก่อน
Notion Formula Chatbot | How to use Notion Formula Chatbot to get answer to Notion Formula Questions
Send Invoice Payment Reminders to Gmail on Automation from Notion | Notion Automation Tutorial
มุมมอง 1097 หลายเดือนก่อน
Send Invoice Payment Reminders to Gmail on Automation from Notion | Notion Automation Tutorial
How to track Personal Finances in a Google Sheet | Personal Finance Tracker 2024
มุมมอง 1037 หลายเดือนก่อน
How to track Personal Finances in a Google Sheet | Personal Finance Tracker 2024
Personal Finance Tracker | How to track personal finances in a Google Spreadsheet in 2024
มุมมอง 1257 หลายเดือนก่อน
Personal Finance Tracker | How to track personal finances in a Google Spreadsheet in 2024
Business Cash Flow Template | How to track cash flow movement in business using @Notion
มุมมอง 2398 หลายเดือนก่อน
Business Cash Flow Template | How to track cash flow movement in business using @Notion
Import Export Tracker | How to track import and export of a business in @Notion
มุมมอง 1038 หลายเดือนก่อน
Import Export Tracker | How to track import and export of a business in @Notion
No, it doesn't work. My notion doesn't recognize the "unaryPlus" command.
BIG thank you!!!
Great video but what if i have several sales persons and i want to know only the total for each one ? can i do that there is no way to find how can i do it ?
@@leoneldonatini5794 Thanks for appreciation. You need to create relational properties for each salesperson onto another database and then in the second database you would be able to see the total sales of all the salesperson individually.
You're the Goat. Thanks
Is this chatbot compatible with Notion Formula 2.0? Your video indicates responses with the prop() function. 2.0 deprecated or renamed several functions and included for new data types and 30 new functions. Does your chatbot include for these? Will your GPT model include for gpt-4o? I did not see, or I missed FAQ, help, support, or updates so I did not know where to ask this. Great work by the way, I love the interface. Best Regards, William
This is exactly what I was looking for. Thank you!
got problem with numbers and it crashed
@@hitthestarz Hi may I know what's the exact problem you facing?
@@theaccountantguy so with transactions i writed the expenses and it giving me only -32$ but its not correct
@@hitthestarz can you reach out to me at notionformyuse@gmail.com. It's hard to figure it out from here. Thanks!
Thank you!!
Welcome!
May I know how can the sum still be calculated automatically if I keep on adding sales person and the amount of sales(increasing row ). This is really important for me ❤
Hi when you add more rows of data onto the first database you need to link the data onto the relational database placed at the bottom to keep the relation of each new row intact. In this way whenever a new row item is added it automatically brings the total sum onto the desired value and gives you the output. Hope this makes sense
as the same *
like after i have finished paying off a card is there a way i can keep that information in the data base without it appearing in the credit cards tab as both amounts due and amounts reming as not the same
It would need to be customised for the same functionality to keep the information intact
how can i record the history of long term spend when the credit cards tab doesn't reset after a month is there a way i can do that thank you for template
Hi as of now the amounts that would be entered would work in cumulative terms. For putting it into different months it would need some form of customisation.
@@theaccountantguy what could I do for that
@@cliffman.456 It would require creating another database for maintaining that and linking the same through a relational property with the original database. Are you aware of how the relations and rollups feature work in Notion?
@@theaccountantguy no not really
Please help sorry I just got the template
I'm Brazilian and I speak little English, but I managed to understand and it helped me solve my problem. Thank you
@@biancacarvalho9121 Glad to hear that. Much appreciated 😊
my guy learn how to make videos
not horrible could be better tho for 9 good start
Thank you for your feedback, yes its a template at the end of the day. Much appreciated! Anyone can customize the same to suit their own requirement.
Thank you very much!
Sorry, this item is not available in your location.
I didn't get this.
@@theaccountantguy I mean This happen with me. I am from Yemen.
hello! for now, i don't think i'll be able to buy any of your templates - but i plan to in near the future! they seem really useful. can i maybe try to use your video for inspiration to built my own? it seems a bit hard, but at least i'll learn 1 or 2 things.
Yes for 😊
6:21 How did you put that list view of the transactions between the properties and the comments??? I didn't even know that was possible.
Hi that is possible by using relation and rollup and enabling the relational properties inside each property.
@@theaccountantguy Thank u, man
Hello. Thank you very much for the detailed instructions. Perfect! Would it be possible to ask for a similar guide when I enter the following properties into a simple task database: task name the day of the task the estimated time of completion of an individual task in hours, for example (ie not a time interval as in the calendar - e.g. 12:30-13:30). So I can have multiple tasks in one day. But I would like (probably using a second database) to be able to add up the individual values of the task completion time in one day. The purpose is (if I don't care about the order of the tasks and no task has a specific time) to get this total to notify me that I have scheduled tasks over the daily limit of e.g. 8 hours (the tasks so far for that day have a total of 7 hours for example) and I want to add another one lasting 2 hours ... so with this last task I would exceed the set maximum of 8 hours).... If it were possible - thank you very much in advance for your time!
Hi yes that's possible. We would need to use a formula to calculate the difference in time. Once the difference is calculated for each time then we can use relation and rollup to get the sum of all hours for a particular day onto another database and then from there we can calculate the differential time for the required time difference of each day's all tasks combined. Hope this gives you a starting solution to get the desired job done.
how to add the salary? thank you
Hi you can jump to the Accounts part and create a new record by the name of "Salary". Once that is entered, you can enter the transactions under the Salary head to update the same records.
Just what I needed. Thanks!
In "Bills Details", what are the category, priority, and expense type properties related to? I'm having trouble getting started with even a skeleton template?
These are the properties used to define expenses for bill payments.
Such a helpful video, thank you!
*promo sm*
a human teacher would be helpful here for people who don't have prior experience. This auto voice and the fast moving cursor is impossible.
Basically there are 2 ways to subtract 2 numbers. 1. Use subtract() to subtract 2 nos, eg subtract(prop 1, prop 2) to subtract 2 nos. 2. Just use the "-" symbol to subtract 2 nos, eg (prop1-prop2) to find difference of 2 nos. Here prop 1 and prop 2 are the 2 nos placed in 2 columns in the database. Hope this makes sense 😊
Very neatly organized! Appreciate it!
how would I do this if for example If I have daily entries of 4-5 rows, and I want to sum every 4 rows for each day
There are ways for this, but it can't be done directly, what can be done is to create an additional column where you can specify "add this" for every 4th row of the data and then use a formula to add only those rows. Hope this makes sense!
is there a way to display that sum at the bottom of the first data base on top on the page?
no, as far as I know currently you can't populate a sum value outside a database.
This is impressive! I've been tentatively thinking I need to watch those 1hr+ videos on the Notion formulas which I know I need to dive in a learn, but keep putting off 😅 So this should be very useful. Cheers 🤝
Thanks, hope this helps you out. 🙂
Great tool, great video. Thanks for sharing.
Much appreciated 😊
Can you get the total sum without having to manually select all the pages in the rollup ? like you did here you selected Eric, Harry, Peter
Hi no that won't be possible as there is no direct one way link with the total sales to be reflected in the adjacent column other than using a rollup from a second database.
can total hours count minutes also ? like 16 Hrs 45 Min or 16:45 ?
yes it can be customized to fit as per that time format
Hello. I see in some of your templates, you have created some button automations. Do you have them in this version? And - if I want to buy this one, what do you call it?
Hi @amylinn1337, this template is best suited for Individuals, Freelancers and Teams which are available as versions in the product page. As for button automations, currently this template doesn't have the same. But it can be included as per your requirement. I also have another template "Small Business Bookkeeping" which supports button automations and similar functionality as you see here. Thanks for your time and consideration! Let me know how it suits your needs.🙂
Also, the calculation to figure out Debt Free date isn't working for accounts that have a 0% interest. How can I fix that?
Hi kindly check the reply on your previous comment. Thanks!
Hi! I think I'm missing how to create the "Debt Free (in months)" tab. Is it a formula and if so, what would that be? I followed everything else, but missed that somehow.
Hi @marthamcgiver Yes the "Debt Free (in months)" is calculated from the following formula: if(prop("Interest Rate") == 0, round(((prop("Loan Amount") - prop("Additional Repayment")) / prop("Min. Payment")) * 100) / 100, ceil(round((-log10(1 - ((prop("i") * (prop("Loan Amount") - prop("Additional Repayment"))) / prop("Min. Payment"))) / log10(1 + prop("i"))) * 100) / 100)) In this formula is the interest rate is "0 %", the calculation is done differently than other interest rates as shown above. Essentially the above formula captures the time it takes to be free of debt considering the "Additional Repayment", "Loan Amount" and the "Minimum Repayment" amount of the loan along with the interest rates as considered above. Let me know if you have further questions. Thanks!
Thank you!! This is very well done
Most welcome. Much appreciated 🙂
When you have severals numbers to substract, how you can do this ? for example : 40 - 2 - 5 = ?
Then you can simply use 3 properties in the formula, eg: No1 - No2 - No3. It's just like Excel how we use the functions
Thank you!
THANK YOU
Great video! I never thought of using notion like this for keeping track of events and stuff. Your steps were easy to follow. Thanks a lot, this is going to be super helpful for me. Could you make finance related videos to build from scratch 😊👍
Sure thing, thanks for the appreciation 🙂
how to set mothly budget with custome date. for example : period nov-dec means 25nov-24dec... so, total budget, wallet, expense and all sub-page will be recapted based on period date not start on first date
For that in the period section we can enter the custom period, eg 25Nov-24Dec and then it will take the date of entry into that period for your consideration. As we will incur the expenses for that specific period it will keep adding the expenses into that specific period. Hope this makes sense. Let me know if you have further questions. Would love to answer the same.😊
This is really good
Glad you liked it 😊
Music is distracting
Hi follow the link in the description, it has complete video instructions for the same 🙂
Trying to use the template but I can’t figure out how to add more debt accounts than what is shown.
Hi Brian. Kindly send me an email with the issue I will be happy to resolve the same 😊
Hi there. Have sent an email with the solution for the same. Hope this helps 😊
Template Link 👇 theaccountantguy.gumroad.com/l/smallbusinessbookkeeping
😏 P r o m o S M
Complete Video - th-cam.com/video/eH-tzqmWITk/w-d-xo.htmlsi=_zC23obB1ttWTaOx Template Link 🔗 - theaccountantguy.gumroad.com/l/notionbillspaymentreminder
Copy and paste this link to watch full video - th-cam.com/video/8npw7X-61KM/w-d-xo.htmlsi=y4097tdlRTCxnD6D Template Link - theaccountantguy.gumroad.com/l/notiondebtpaymentreminder
Awesome! 🔥🔥
Thanks much appreciated 👍