10 Types of Small Capital Business with Big Profits, Guaranteed to Sell Well!

-
Image
10 Types of Small Capital Business with Big Profits, Guaranteed to Sell Well! Owning a business with upper case is not any longer troublesome. particularly within the era of technology and social media that have penetrated. Opportunities to induce massive profits square measure more and more wide open. However, running a business needs a mature mentality and idea. do not let the little capital business that you just run rather than profit even stagnate. In this all-digital era, you must are given the convenience to promote your merchandise and expand your merchandise vary while not having to pay tons of cash. Type of Business upper case massive Profit If you're still confused regarding selecting a business with tiny however profitable capital, this text can provide you with a outline of many forms of businesses that you just will run with upper case. in fact with nice profit opportunities. 1. Laundry Business Many people have chosen to pay money for the services of ot
Post a Comment

How to Create a Daily Cash Book in Excel (Download File)

-

How to Create a Daily Cash Book in Excel 

Financial records

Creating a Daily Cash Book in Excel can make it easier for you to fill in the required financial data. With the Excel Cash Book Application, the balance will be automatically generated according to the debits and credits entered. So this application will be a bit similar to the savings system at the Bank.

Daily Cash Book is something that is very important to have for a store, company or personal. You can make daily, weekly or monthly financial reports using this cash book application. With the Cash Book, income and expenditure reports will be written very neatly and have clear information.

Example of Cash Book Format for Financial Statements

Here I will show you the Daily Cash Book Format which in the next point will explain how to make it. Look at the following picture:

Financial records

Pay attention to the picture above, In the Cash Book Application that will be made there are several points that must be in the table. In the Cash Book there is a description (title), date, entry/expenditure statement, debit, credit and balance.

To fill it out, you only need to enter the date, entry/expenditure information, debit and credit only. Meanwhile, “BALANCE” will be filled automatically according to the Debit or Credit entered.

How to Make a Simple Diary in Excel

After seeing an example of a cashbook format, the next step is to learn how to make it. Here I use the Microsoft Excel application with the IF and AND function formulas.

1. Open the Ms. Application. Excel on your computer or laptop.

2. Create a new workbook, then create a table as shown below:

Financial records

Look at the picture above:

– Create a table with the title “CASH BOOK”. Then Add Column Title Date, Description, DEBET, CREDIT and BALANCE.


– In the Date Column section, use Number Date Format. As for the DEBET, CREDIT and BALANCE sections, use the Accounting Number Format

**Use the same Cell Address as in the Example above. If different, then the formula used will also be different.**

3. After creating a table and its initial design (like the example above). Then the next step is to enter the Formula in the Balance Column so that it can be filled automatically.

4. Using the Formula in the Balance Section:

Financial records

Caption:

Activate Cell F4 Then enter the following formula:

=D4

Activate Cell F5 Then Enter the Following Formula:

=IF(AND(D5=””,E5=””),””,F4+D5-E5)


After that, in the Cell F5 section, use the Auto Handle Function to fill the bottom with the same formula.

Financial records


5. After that, Fill in the Debit and Credit sections. If successful, then the Balance Section will be filled automatically.

6. Done.

You can make the Simple Cash Book application above using a simple function. How to use it?? After following the tutorial above, you have successfully created a Simple Cash Book Application. To use it, you only need to enter information on income/expenditure, DEBET (Money in) and CREDIT (Money out). The Balance section will be filled automatically.

Download Simple Cash Diary Application For Financial Statements

You can download the cash book application file above for study material. Download the Excel file here:


Download Simple Cash Book App

Location: Amerika Serikat

Comments

Post a Comment

Popular posts from this blog

10 Types of Small Capital Business with Big Profits, Guaranteed to Sell Well!

-
Image
10 Types of Small Capital Business with Big Profits, Guaranteed to Sell Well! Owning a business with upper case is not any longer troublesome. particularly within the era of technology and social media that have penetrated. Opportunities to induce massive profits square measure more and more wide open. However, running a business needs a mature mentality and idea. do not let the little capital business that you just run rather than profit even stagnate. In this all-digital era, you must are given the convenience to promote your merchandise and expand your merchandise vary while not having to pay tons of cash. Type of Business upper case massive Profit If you're still confused regarding selecting a business with tiny however profitable capital, this text can provide you with a outline of many forms of businesses that you just will run with upper case. in fact with nice profit opportunities. 1. Laundry Business Many people have chosen to pay money for the services of ot
Read more

7 Examples of Profitable Small Businesses You Should Try

-
Image
7 Examples of Profitable Small Businesses You Should Try      The needs of life are increasing every year, especially if you have school-age children, the needs will definitely increase. These days all necessities are expensive, that's why you have to work even harder to earn more income to meet your needs. However, it is important to note that for those of you who work with other people, for example as a public or private employee, factory employee, laborer and others, you will get a fixed monthly salary, so if the necessities of life continue to rise you will always be short every month. Therefore, nowadays many people are doing small businesses that can be profitable, the goal is none other than to make ends meet. There are many people who run small businesses that have proven to be profitable, profitable, and can even exceed their monthly salary. Here are 7 examples of profitable small businesses: 1. Laundry If you have a house in a densely populated area and the ma
Read more

Home Business Idea with Small Capital but Big Turnover

-
Image
Home Business Idea with Small Capital but Big Turnover      As is known, there are many home business ideas that you can immediately run. You just choose the home business idea and immediately open it even with only a small capital. The income obtained from this home business idea will certainly increase your income every month considering the price of basic necessities has soared and has been exacerbated by the crisis due to the corona virus pandemic for almost two years. Some of the things you need before deciding on the right home business idea for you to run, of course, is the availability of capital. However, you don't need to worry, this article tries to give you inspiration to choose what home business idea is right for you. Even with a capital that is not so large and you will get a large turnover as the business develops. Home Business Ideas with Small Capital In fact, there are tons of home business ideas that could potentially make you big profits. Although of cour
Read more