All Recent posts, Info tech, softwares

Download and learn how to make your own bank statement format in Excel Sheet with Dr and Cr sign


Hello friends, yesterday night i make some tricks in Excel sheet, fortunately i found an idea and make a Bank Statement sheet in Excel.

I am Share this Sheet and also share how you make this your own.

Click here to Download Bank statement format in Excel

Learn How to make your own

1. Open the Excel program from your start menu or by double clicking a shortcut on your desktop.

2. Label your headings on the top row and leave open columns between your headings. A1 should be labeled “Method;” B1 should be blank; C1 should be “Date;” D1 should be blank; E1 should be “Description;” F1 should be blank; G1 should be “Debit;” H1 should be blank; I1 should be “Credit:” J1 should be blank; K1 should be “Balance;” L1 should be blank; and M1 should be “Cleared.”

3. Change your blank column widths to separate the data you will insert later. Click on the first blank column (B), hold the “Ctrl” button down and click on the other blank columns, (D, F, H, J; L). They will be highlighted in black. Right click your mouse on any black column. A drop down bar will open, click on “Column Width.” Change to “2” and click “OK.”

4. Change your other Column Widths that will hold data to the size you desire. The most noticeable change will be the “Description” column. Change this to a Column Width of “27” so it can hold enough text to record your information.

5. Format cells to hold currency. Click on “G,” hold down the “Ctrl” button and click on “I” and “K.” Right click on one of the black highlighted columns to see the drop down bar. Select “Format Cells.” On the “Number” tab, select “Currency” and choose your decimal places and dollar sign. This will make your form consistent.

6. Insert your starting balance. On the first row, you want to insert only your starting balance in the “K2” cell. This will be the number all your debits and credits will be added or subtracted from

7. Insert your data beginning with Row 3. Check #’s, ATM, Deposit and other methods will be entered in Column A. Insert the date of the transaction (you may format this column by right clicking on “C,” “Format Cells” and selecting the date format you prefer). Enter the description and amount in the appropriate columns

8. Create a running balance. Click on cell “K3.” On the toolbar, click on the Auto Sum button which appears as a Greek letter “E.” A dotted, moving block will appear on “K2,” and you will see a bar under the toolbars with =SUM(K2). Insert your command after the K2: =SUM(K2-G3+I3) and click “Enter.” You have formatted your cell data.

9. Format the “Balance” column to update as you enter data. Click on the K3 cell, hold down the “Ctrl” button and click the letter “C” on the keyboard. This copies the format of that cell. Click on the K4 cell, hold down the “Ctrl” button and click the letter “V” on the keyboard. This pastes the format into that cell. Repeat the paste process as far down as you prefer

10. Reconcile your Excel spreadsheet to your monthly bank statement. Put an “R” in the Cleared column to indicate that an entry matches your bank statement and has been added or subtracted to your balance.

11. Verify your balance. Your bank statement may be different from your Excel balance. Certain transactions may not have cleared the bank that you have recorded. Take your Excel balance, and add or subtract any amounts that do not have an “R” beside them to your Excel balance. This total should match your bank statement balance.

How To add “Dr” and “Cr” sign in Excel

1. First Open Excel Sheet

2. “Right Click” on A2 Cell

3. Click on Format Cell

4. then Click on Custom and paste the string  to Blank bar (Download below File to view String)

String

5. Click OK.

6. write -5000  in cell A2 and you will see  5,000 .00 Cr

About CA Dushyant Kumar (Maddy)

CA Dushyant Kumar (Author) CA Dushyant is Author and Founder of Carocks. He is a Technology Enthusiast and by profession he is a Chartered Accountant. Loves playing with electronic gadgets and believes in Simple Living. You can reach him at dushyantkumar@hotmail.co.uk | dushkumar2009@icai.org

Discussion

4 thoughts on “Download and learn how to make your own bank statement format in Excel Sheet with Dr and Cr sign

  1. Hello
    I am thinking about taking pro hormones, do you think this is good idea for advanced bodybuilder
    like me? Bodybuilders are satisfied with the results
    after prohormones cycles, just google for – 100% pure muscles
    without side effects – worth a try?

    Posted by Sherman | October 9, 2014, 11:19 PM
  2. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point.

    You definitely know what youre talking about, why throw away your intelligence
    on just posting videos to your weblog when you could be giving us something informative to read?

    Posted by  Troxyphen elite reviews | September 14, 2014, 11:55 AM
  3. I took Prozac and it produced me shed wight.
    Irecentlystarted it once more and that i locate it very simple to avoid these day-to-day temptations to overeat or consume
    the incorrect factors.I really feel complete with
    just a few bites ! But it does have a few negative effects , granted every person is diverse but
    I’ve trouble sleeping ,get sizzling flashes and feel a bit numb .When I’m on it
    , it really is difficult to really feel pure excitement .
    Besides that , it tends to make me general a greater particular person .

    Posted by Http://Www.Bodybuilding.Com/Fun/Build-Muscle-Burn-Fat-Simultaneously.Htm | May 9, 2013, 5:57 AM
  4. Nowadays, I went towards the beachfront with my
    youngsters. I discovered a sea shell and
    gave it to my four year previous daughter and said
    “You can hear the ocean should you put this for your ear.” She placed the shell to her
    ear and screamed.
    There was a hermit crab inside and it pinched her ear.

    Posted by Rodrigo | May 8, 2013, 5:51 AM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Subscribers

  • 2,718,009 and growing....

Follow Us

follow-us-headline twitter1linkedin1youtube1facebook1

Android App

Carocks !!! TBF and ICAI Android App for CA Students Only

Subscribe Us

Carocks Subscription

Whatsapp Updates

Monthly Archive

Important

Carocks.wordpress.com is an Independent website and does not belong to any organisation. This Website is strictly only for CA Students pursuing CA CPT, IPC and CA Final. For CS Students we are just created a website www.icsiedu.wordpress.com

Print ICAI Confirmation letter

Nov 2016 Amemndments

ICAI Nov 2016 Amendments

best teachers for CA Course

DUSHYANT KUMAR
You can be in touch with us and receive latest updates related to CA Students only
Method 1 Download Our Android Application : Click here
Method 2 Subscribe Our Website for daily Email Updates : Click here
Method 3 Join us on our whatsapp broadcast : Click here
Method 4 Subscribe to Rss Feed : Click here
%d bloggers like this: