Kormeeraha kharashku waa muhiim haddii aad miisaaniyad samaynayso ama aad u baahan tahay inaad ogaato halka lacagtaadu u socoto. Foomamka Google^{(Google Forms)} waa dhise foom bilaash ah oo si weyn ugu shaqeeya raadraaca kharash.

Foomamka Google^{(Google Forms)} si aad ah ayaa loo habeyn karaa, marka iyada oo sidoo kale loo isticmaali karo sahamin ahaan, qalabka RSVP , foomka xiriirka, xaashida saxiixa alaabta, ama foom kasta oo su'aal/jawaab kale ah, waxaad ka dhigi kartaa tracker kharashka gaarka ah adiga oo dooranaya su'aalaha la xiriira kharashka .

Kharashka foomamka Google^{(Google Forms)} - ku wuxuu ilaalin karaa wax kasta oo aad rabto oo ku saabsan wax kala iibsiga, iyo maadaama uu si fiican uga shaqeeyo taleefanka, waxaad ku haysan doontaa meel kasta oo aad tagto.

Waxaad joojin kartaa kaydinta rasiidhada ama iskudayga inaad qeexdo kharashka kaarka deynta; Kaliya soo jiid raadraacaha kharashkaaga isla markaaba aad lacag ku kharash garayso si aad u duubto dhammaan faahfaahinta muhiimka ah oo aad u gudbiso xaashida xisaabaadka oo aad dib u eegi karto.

Talo^(Tip) : Eeg liiskayada barnaamijyada dabagalka miisaaniyada iyo kharashaadka^{(best budgeting and expense tracking apps)} ee ugu wanagsan siyaabo kale oo aad ula socoto kharashaadka. Ma aha kuwo la beddeli karo sida foomamka Google^{(Google Forms)} -ka laakiin waxay leeyihiin faa'iidooyin iyaga u gaar ah.

Go'aanso waxa aad Raad-raacayso^{(Decide What To Track)}

Fikradda tracker-ka kharashku waa in aad isha ku hayso waxa aad lacagtaada ku bixinayso, markaa waxa jira tafaasiil kooban oo aasaasi ah oo foomku u baahan yahay in lagu daro. Laakin iyadoo ku xiran waxaad rabto inaad raadraacdo, waxaa laga yaabaa inaad u baahato qaybo dheeri ah oo foomka ah.

Waa kuwan tusaalooyin qaar oo laga yaabo inaad rabto inaad la socoto:

• Qiimaha^(Price) : waa imisa wax kala iibsiga?
• Bakhaar^(Store) : xagee ku bixinaysaa lacagta?
• Description : Maxaad lacag ku bixinaysaa?
• Qaybta^(Category) : Waa maxay nooca iibsashada (madadaalada, cuntada, biilasha, iwm.)?
• Habka lacag-bixinta ee la isticmaalay^{(Payment method used)} : Sideed wax uga bixinaysaa (kaarkee/bangi/app)?
• Yaa watay kharashka^{(Who ran the expense)} : Haddii ay jiraan dad badan oo isticmaalaya foomka
• Xusuusin^(Notes) : Ma jiraan qoraallo dheeraad ah oo aad u baahan tahay inaad sameyso?

Markaad go'aansanayso waxa lagu daro Google Forms kharash tracker, maskaxda ku hay in aad rabto in beeruhu noqdaan kuwo ballaadhan intii suurtogal ah si ay ugu dabaqaan wax kasta oo aad iibsanayso. Khasab ma aha inaad u baahnid beer ku weydiinaysa nooca cuntada aad iibsanayso, tusaale ahaan, haddii aanay tani ahayn kaliya raadraaca kharashka cuntada; Waxaa laga yaabaa inaad u baahato inaad sidoo kale tan u isticmaasho duubista bixinta kirada iyo biilasha taleefanka.

Qoraalkaas, waxaad samayn kartaa mid kasta oo ka mid ah goobaha ku jira foomka tracker-ka kharashkaaga loo baahan yahay ama aan loo baahnayn. Sidaa darteed, haddii aad rabto meel gaar ah oo runtii ah shay, kaliya ka dhig inaan loo baahnayn si aadan ugu baahnayn inaad u isticmaasho wax kasta oo kala iibsiga ah.

Dhis Tracker Kharashka Foomamka Google^{(Build The Google Forms Expense Tracker)}

Kani waa muunad kharash raadiye ah, markaa kaaga, sinaba, uma baahna inuu u ekaado midkan oo kale. Waxaan isticmaaleynaa su'aalo ballaaran oo leh xitaa xulashooyin jawaabo ballaaran si aan u muujinno sida tani u shaqeyso. Waxaad baran doontaa in tafatirka foomka uu yahay mid aad u fudud, markaa waa inaadan wax dhib ah kala kulmin habayntaada naftaada.

• Fur foomamka Google-^{(Open Google Forms)} ka
• Dooro Banaan^(Blank) si aad u bilowdo foom cusub.
• Ku beddel foomkaaga wax la aqoonsan karo.
• Dooro sanduuqa koowaad oo u beddel jawaab gaaban^{(Short answer)} .

• Magaca midkan Qiimaha^(Price) , xaqiiji in lambarka^{(Is number)} la muujiyay, ka dibna calaamadee badhanka loo baahan yahay .^(Required)

• Isticmaal calaamadda lagu daray liiska ka baxsan dhanka midig si aad ugu darto su'aal cusub, laakiin markan dooro xulashooyin badan^{(Multiple choice)} .
• Magaca mid ka mid ah Dukaanka^(Store) , ka dibna ku buuxi xulashooyinka jawaabta dukaamada caadiga ah ee aad wax ka soo gadato. Kuwo kale^(Other) ayaa lagu daraa si toos ah, markaa haddii aad ka soo iibsato dukaan kale, waxaad ku qori kartaa halkaas.

• Ku sii wad^(Continue) foomka adoo samaynaya dhammaan su'aalaha kala duwan ee aad rabto inaad naftaada waydiiso mar kasta oo aad wax soo iibsato. Isticmaal talooyinka kor ku xusan, sida habka lacag-bixinta iyo su'aasha sharraxaadda, si aad naftaada u siiso tafaasiisha ugu badan ee suurtogalka ah. Tani waxay ku iman doontaa anfaca dambe markaan turjuno dhammaan natiijooyinka foomka.
• Isticmaal badhanka horudhaca (astaanta isha) ee ku taal xagga sare ee foomamka Google^{(Google Forms)} si aad u hesho URL foomkaaga. Waxaad tan la wadaagi kartaa qof kasta oo aad rabto inaad ku isticmaasho foomka, ama u soo dir naftaada si ay si sahal ah taleefankaaga uga hesho.

Tani muhiim maaha, laakiin foomkaaga waxa kale oo ku jiri kara sawirro, cinwaano, iyo nidaam midab gaar ah. Foom midab leh ayaa laga yaabaa inuu ka dhigo kharashaadka la socodka madadaalo, haddii ay taasi suurtogal tahay! Astaanta rinjiga ee ku taal xagga sare ee bogga waa meesha aad u tagto isbeddelladaas.

Deji Xisaabinta^{(Set Up Calculations)}

Gelin kasta oo ka soo baxa foomkaaga waxa lagu soo ururiyaa xaashida si fiican loo habeeyey ee Google Sheets . Ka dooro JAWAABAHA^{(RESPONSES )} xagga sare ee foomkaaga ka bacdina ku dhufo calaamadda xaashida si aad dib ugu magacawdo xaashida (haddii aad rabto).

Ka dib marka xaashigu furmo, samee tab cusub xagga hoose oo u magacow wax sida Xisaabinta^{(Calculations)} . 

Halkaa, waxaad ka samayn kartaa wax kasta oo Google Sheets uu taageero: isku gee dhammaan kharashyadaada muddo cayiman, samee garaafyo si aad u fahanto kharashyadaada, eeg cidda lacagta ugu badan ku bixinaysa, ogow dukaamada kugu kacaya kharashka ugu badan, iwm. .

Isticmaalka noocyadaas qaacidooyinka Google Sheets waa mid ka baxsan baaxadda maqaalkan, laakiin aan eegno wax runtii fudud sida in la isku daro dhammaan kharashyada qof kasta si aan runtii u aragno cidda ugu badan ee kharash garaynaysa. Waxaad had iyo jeer la qabsan kartaa caanaha caanaha wadarta inta aad ku bixinayso dukaan kasta.

Habka ugu fudud ee wadarta kharashaadka oo dhan iyada oo aan loo eegin qofka sameeyay wax kala iibsiga, waa in la maamulo wadarta^(sum) qaacidada, sida tan:

=sum(‘Form Responses 1’!B:B)

Xisaabintani waxay u shaqaysaa tusaale ahaan sababtoo ah tiirka qiimaha ee jawaabaha foomka waxay ku yaalaan tiirka B.

Waa kuwan qaacidada Google Sheets oo tusinaysa eegid aad u faahfaahsan oo qof walba ku bixinayo:

=sumif(‘Form Responses 1′!G:G,”Jeff”,’Form Responses 1’!B:B)

Habka ay tani u shaqeyso waa adigoo gelinaya sumif^(sumif) ka dibna dooranaya tiirka ay ku jiraan magacyada ( G tusaale ahaan). Qaybta xigta waa aqoonsiga magaca, Jeff . Ugu dambeyntii, dooro ciwaanka tiirka leh qiimayaasha si marka tiirka kale uu u dhigmo magaca aan ku daba jirno, waxay ku dari doontaa kaliya qiimahaas.

Ka eeg liiska Google ee hawlaha xaashida Google^{(list of Google Sheets functions)} siyaalo kale oo aad uga tarjumi karto xogta foomkaaga. Si kale oo aad ku arki karto kharashyadaada waa jaantus ama garaaf; Google wuxuu leeyahay cashar^{(Google has a tutorial)} ku saabsan samaynta taas.

How To Use Google Forms As An Expense Tracker

An еxpense tracker is vital if yоu’re budgeting or уou need to know where your money iѕ going. Googlе Forms is a free form bυilder that works great as an еxpense tracker.

Google Forms is heavily customizable, so while it can also be used as a survey, RSVP tool, contact form, product signup sheet, or any other question/answer form, you can make it into a custom expense tracker by choosing expense-related questions.

A Google Forms expense tracker can keep tabs on anything you want regarding a transaction, and since it works great from a phone, you’ll have it with you wherever you go.

You can stop saving receipts or trying to decipher a charge on your credit card; just pull up your expense tracker right after you spend money to record all the important details and submit it to a spreadsheet you can review later.

Tip: See our list of the best budgeting and expense tracking apps for some other ways to track expenses. They’re not as customizable as Google Forms but they do have their own benefits.

Decide What To Track

The idea of an expense tracker is to keep tabs on what you’re spending your money on, so there are a few basic details that the form needs to include. But depending on what you’re wanting to track, you might need some extra fields in the form.

Here are some examples of what you might want to track:

• Price: How much is this transaction?
• Store: Where are you spending the money?
• Description: What are you spending money on?
• Category: What type of purchase is it (entertainment, food, bill, etc.)?
• Payment method used: How are you paying for it (which card/bank/app)?
• Who ran the expense: If there are multiple people using the form
• Notes: Any extra notes you need to make?

When deciding what to include in a Google Forms expense tracker, keep in mind that you want the fields to be as broad as possible so that they can apply to anything you’re purchasing. You don’t necessarily need a field that asks what kind of food you’re buying, for example, unless this is solely a food expense tracker; you might want to also use this for recording rent payment and phone bills.

On that note, you can make any of the fields in your expense tracker form required or not required. So, if you do want a really specific field for something, just make it not required so that you don’t have to use it for every transaction.

Build The Google Forms Expense Tracker

This is a sample expense tracker, so yours, by no means, needs to look exactly like this one. We’re using broad questions with even broader answer options to show how this works. You’ll learn that editing the form is extremely easy, so you shouldn’t have any problem customizing it for yourself.

• Open Google Forms.
• Select Blank to start a new form.
• Rename your form to something recognizable.
• Select the first box and change it to Short answer.

• Name this one Price, confirm that Is number is shown, and then mark the Required button.

• Use the plus sign from the menu off to the right to add a new question, but this time choose Multiple choice.
• Name this one Store, and then fill out the answer options with the usual stores you shop at. Other is added by default, so if you end up making a purchase from a different store, you can type it in there.

• Continue through the form making all the different questions you want to ask yourself each time you buy something. Use the suggestions above, like the payment method and description question, to provide yourself with as much detail as possible. This will come in handy later when we interpret all the results from the form.
• Use the preview button (the eye icon) at the top of Google Forms to get the URL to your form. You can share this with anyone you want to use the form with, or send it to yourself so that it’s easily accessible from your phone.

This isn’t necessary, but your form can also include images, headings, and a unique color scheme. A colorful form might make tracking expenses fun, if that’s at all possible! The paint icon at the top of the page is where you go for those changes.

Set Up Calculations

Every entry from your form is gathered in a nicely formatted spreadsheet at Google Sheets. Select RESPONSES from the top of your form and then click the spreadsheet icon to rename the spreadsheet (if you want).

After the spreadsheet opens, create a new tab at the bottom and name it something like Calculations. 

From there, you can do anything that Google Sheets supports: add up all your expenses for a given time period, create graphs for a visual understanding of your expenses, see who’s spending the most money, identify which stores are costing you the most, etc.

Using those types of formulas in Google Sheets is out of the scope of this article, but let’s look at something really simple like adding up all the expenses for each person so that we can really see who’s spending the most. You can always adapt the formula to total how much you’re spending at each store.

The easiest way to total all the expenses regardless of the person who did the transaction, is to run the sum formula, like this:

=sum(‘Form Responses 1’!B:B)

This calculation works for our example because the price column from the form responses is in column B.

Here’s a Google Sheets formula that shows a much more detailed look at how much each person is spending:

=sumif(‘Form Responses 1′!G:G,”Jeff”,’Form Responses 1’!B:B)

The way this works is by entering sumif and then choosing the column that contains the names (G in our example). The next part is identifying the name, Jeff. Finally, select the column heading with the prices so that when the other column matches the name we’re after, it will add just those prices.

Look through Google’s list of Google Sheets functions for some other ways to can interpret the data from your form. Another way to see your expenses is with a chart or graph; Google has a tutorial on doing that.

Related posts

• 5 Shaqooyinka Qoraalka Xaashiyaha Google ee aad u baahan tahay inaad ogaato

• Sida Looga Saaro Xudduudaha Shaxda Google Docs

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Sida Google Docs Chat uu kuugu caawiyo inaad ka wada-shaqayso dukumentiyada

• Sida loo Geliyo Watermark gudaha Word iyo Google Docs

• Sida Loo Beddelo Farta Ugu Dambeysay Ee Xafiiska Apps-ka

• Sida loo isticmaalo Excel's What-If Analysis

• Sida loo hagaajiyo Bookmark aan lagu qeexin qalad gudaha Word

• U beddel hanuuninta muuqaalka muuqaalka Google Docs

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Sida Loo Hagaajiyo Muuqaalka Ku dheggan Profile-ka Loading

• Hagaaji Dhamaadka Tag Start Tag Isbarbar-dhigga Ciladda Marka la furayo faylalka DOCX

• Sida loo Beddelayo Cabbirka Islaaydhka ee PowerPoint si loo soo bandhigo Wanaagsan

• 9 Siyaabood Oo Loo Furo Dukumeenti Kalmadeed La'aanteed

• Sida loo tirtiro bogga Microsoft Word

• Sida loogu daro Qoraallada Footnotes ee Word

• Hagaaji MS Office "Ma Xaqiijin Karo Shatiga" Fariinta Khaladka

• Sida loo sameeyo dukumeenti PDF gudaha Microsoft Office

• Sida Taariikh ahaan loogu kala saaro Excel

• Geli Xabad dhexda Weedha Erayga