Bookkeeping Skills for a Secretary

Hey, boss-types and employer-types:

I am considering quitting my job (long story, and since I’m home from the office, I don’t want to dwell on the negatives. I’m too tired of exhaustion, tears, frustration, and stress. Not to mention going in on my days off and long weekends to try and catch up, when “catching up” is hopeless.)

I am looking for a new administrative assistant / secretarial position. However, my math and arithmetic skills are weak. (I love words and hate numbers.) Most of the job postings want some kind of bookkeeping skills, along with the skills and experience that I do possess.

So, my question is, **what do you consider the basic bookkeeping skills for a secretary to have? ** I need to know what I need to know.

Thank you!

Excel. Learn how to write formulas, and just as important format spreadsheets to print out decently, and you will be a god in the office.

Learn quickbooks then you truly will be an office goddess. If you wanna play around you can do a free demo of quickbooks online for 30 days or 3 months @ 9.95.

Minmal math required…software does all the heavy lifting, you just need to be accurate.

linky

My brother’s secretary must be able to classify properly the “facturas” (bills), the “órdenes de pago” (negotiable IOUs) and the “other”. Actual bookkeeping is done, well, by the bookkeeper.

I took a course years ago in “bookkeeping by computer,” with a program that’s very popular in Spain. The rest of the class were secretaries and similar who actually did bookkeeping every day, sometimes for several companies. I had the chance to take an accounting class in HS but chose Draftsmanship, so all I knew about bookkeeping going into the course was that “accountants don’t like the color red because it’s used for negative amounts.”
What they actually knew about bookkeeping… was less. If you understand “double entry” you’ve got 90% of the job done. The difficult part is figuring out which “accounts” the two entries have to go on; an accounting program does the rest by itself. And they usually have the function of being able to associate pairs of accounts so that for example if you make an withdrawal entry for “money in Mybank”, the corresponding amount goes to “cash in wallet” automatically.

You’re like me. Hatin’ the numbers! I would choose ads that don’t put a hard emphasis on bookkeeping or Excel and then in the interview, tell them it isn’t your strong suit but you’re capable of taking on “light” excel duties. Also, I’ve found that they want less bookkeeping and more statistical stuff for the most part. As others have said, the $$$ stuff is done by a bookkeeper or accountant. Everyone else is tallying up how many widgets were sold in a given period. That’s my experience, anyway.

I doubt you will need to know double entry accounting, but the basics might help so you have an idea why people are getting so worked up about what seem like an arbitrary choices.

Double Entry Accounting Basics:

‘Double’ entry refers to Credits and Debits. Every entry will have a credit and a debit. (Single entry is what most people do with a checkbook or savings account. Every transaction is a single positive or negative number.)

A credit is NOT a positive entry nor is a debit a negative entry. If you like words, think of it this way: it’s to your credit to go down on an ass. Of course, an ass is an asset.

If you look at “the books” on a balance sheet, you will have two sides that are always in balance; assets on the left, liabilities and equity on the right. The two sides are always in balance because the balance sheet is like a teeter-totter.

What happens on the right side of the teeter-totter is the opposite of what happens on the left side. Going down on a liability is a debit.

A real quick transaction… cash is an asset. It is immediately available, so it goes at the top of your asset list on the left. Inventory is also an asset, but you have to sell it before you can realize a profit (equity) or get your cash back from it, so it goes at the bottom of your asset list. If you spend cash to buy inventory, you enter a credit to cash (which goes down because you have less of it) and a debit to inventory. Note that the credit and the debit are on the same side of the balance sheet.

Often, a company will borrow money to buy inventory. Because the money needs to be repaid, it is a liability. In this case, the money goes into cash: a debit (cash goes up). The corresponding credit is to Loan #1 which is a new liability which also goes up. For this transaction, the credit and the debit are both positive. They are also on opposite sides of the balance sheet.

The borrowed money will need to be paid back over time, let’s say five years. There are also other liabilities such as the phone bill which needs to be paid every month. The loan is long term debt and goes at the bottom of the liability list.

When the phone bill is paid, the transaction goes like this: cash goes down (a credit) and phone bill goes down (a debit). When cash is spent on office supplies, for example, that is an expense. Cash goes down and expenses go up. (Expenses go on the right side of the balance sheet.) Expenses and short term liabilities are cash leaving the business.

Since this is already overlong, I’ll just try to finish with this. Businesses try to avoid paying short term liabilities and expenses with long term debt. Cash that is spent on long term assets — items that last more than one year — is handled as though some portion of it is being spent every month over the lifetime of the asset rather than all at once. The asset depreciates over its useful lifetime.

Classifying transactions accurately is a huge part of managing a business.

For example, as a business does more business it costs more to buy more inventory (or pay more salary or buy more fuel or whatever) so there is less cash, but accounts payable (an asset) goes up. Unfortunately, accounts payable takes awhile to become cash. So the balance sheet balances — it always does — but the business is going to need an influx of cash to stay in business. A lot of start up businesses crash because of that fact. They have tons of sales, but no cash.

Man, SiXSwordS, that went beyond what I meant by double entry :smiley:

My classmates in that course had to do the data entry parts of bookkeeping and pull reports; the interpretation of “so what does this report actually mean” (i.e., “are we low on cash flow or should we put some into short-term CDs?”) was always done by someone else. But they still had to be able to figure out where each of the two entries went. That would actually be the high end for a “secretary with bookkeeping duties.”

Some people want a secretary that will enter their expenses into the expenses webpage, when they say “bookkeeping ability.” Like so many job-ad items, it often doesn’t mean what it says.

Thanks for the responses so far, folks! SiXSwordS, I’ll probably end up printing out your post and thoroughly reviewing it. Very interesting, and good to know. (My only bookkeeping-for-dummies course was many, many moons ago, and all knowledge has withered and died.)

I will definitely be brushing up on my Excel stuff (I’ve got Excel on my home computer, so there’s no excuse) and watching the thread as avidly as the want ads. My present office has an accountant and a junior accountant, so I’ve been able to avoid AP/AR and other stuff, but I wouldn’t expect that to be the case in other places.

If you love words and hate numbers, I encourage you and wish you luck finding a job with minimal accounting. I encourage you to hold out as best you can. I am a firm believer in everyone learning Excel, because it can be a huge timesaver. But if you are not attuned to numbers, you may be setting yourself up for a lot of stress. People with numbers sense will make fewer numerical errors. People without that sense will make more errors, and will bear the brunt of people who are upset when those errors come to light. Sometimes a decimal point is just a decimal point, but sometimes it’s not, y’know? Just like as a word person you will have better than average results getting written material to come out without misspellings, grammar errors, and typos, and may go nuts at people who don’t catch “the obvious.” I say this not to discourage you from learning, but to encourage you to also think about what type of job will be a good fit and not send you from the frying pan to the fire in terms of stress.

Yeah, sorry. I wrote that mostly in the quick reply window and didn’t really realize I had gone so far overboard until I was almost ready to post.

My point was that it helps to understand the underlying issue, even if you’re not the one responsible for cash flow and accrued depreciation on long term fixed assets improvements.
I was the proverbial fly-on-the-wall for a very emotional argument between one bigwig and another. Bigwig A had a budget item for a project, but Bigwig B was classifying material and labor for the project as expenses because no single item passed the test for an asset, even though the project as a whole did. Obviously, that had a major impact on Bigwig A’s expenses.

To me, it seemed ridiculous and arbitrary. Once I realized what was really going on, I understood it a lot better.

For me, it’s easier to do my job when I understand why it’s being done and not just how it’s done. But you’re right that secretarial book keeping probably won’t involve break even analysis or A/P turnover ratios.

It’s hard to say. I almost think they mention it to be sure you know ahead of time that’s it’s not strictly secretarial, so if someone is functionally innumerate they will know. But it’s nothing you can’t handle.

They may mean being comfortable opening a file already created in Excel and adding information to it. It may mean taking a printed report or running a report, and checking items off. Or being able to navigate in something like Quickbooks and adding items to an existing system, or do things like mark off cleared checks for a back rec or something. I can’t imagine it would mean creating anything complex from scratch or doing accounting work, but as you become comfortable you could certainly grow into that. And no one expects you to do math or arithmetic in your head; that’s what the machines are for. :slight_smile:

When you find out what system they use, it’s either Excel which you’ll be fine with, or something I’m sure many of us use, so just ask us for tips.

Please don’t let this scare you when applying or interviewing. They don’t expect you to plunge right in and they’ll have their own way of doing things which they will want to teach you anyway.

Commenting on what SiXSwordS posted, yes, it’s essential to code transactions correctly so they hit the financial statements correctly. HOWEVER, you would be working in a system that is already set up to record transactions to the right section of the financial statements, and you wouldn’t have to make this judgment.

If you are working in QuickBooks and choose “Office Supplies” as your category for the $20 you have spent, the system has been set up to debit Expenses and credit Cash as the “background information” behind the category Office Supplies. The system does that accounting thinking for you. So again, it’s a matter of understanding a system and not inventing something from scratch.

This is not to discount the larger issues of accounting decisions such as the projects assets example, but those would be made at a different level.

If we said anything about “bookkeeping” for our admins, it would be things like filling out deposit slips, matching paper to paper (like check stubs to bills, check vouchers to invoices), some basic Excel data entry, keeping track of entrance and exit of employees on bills for insurance, uniforms, etc. In other words, not really number crunching.

Savannah, when I was in your position I took a continuing education class on QuickBooks at my local community college. It was a six-week class that met once a week in the evening. It was well worth doing. You may want to look into doing something similar for QuickBooks and Excel if something like that is available in your area. If nothing else, it will give you confidence that you can use these systems.

edited
Two quick comments.

The above is excellent advice. I recently took a four session course that was about four hours each session. It was geared toward first time small business owners and it covered the basics plus common pitfalls. Worth every cent!

As for what gigi said, it’s all true about the computer doing it for you. That means the math and some of the categorization. (Remember, computers is dumb! Anything they do for you you should check twice! Then have someone else check it too.) However, I think one needs to know what the computer is doing for you in the same way you need to know what a calculator is doing.

I see a lot of work that’s filled with errors because someone sat down at an adding machine that was set differently than they expected, but they just wrote down the numbers that popped up on the screen.

That said, where I work there aren’t any people in the finance, HR, or billing departments who are as good as I am at math and I am profoundly retarded by SDMB math standards. All of those people are really good at their jobs.

This bears repeating, understanding the mechanics of chart of accounts and such is the biggest concern for something like quickbooks. The math is done for you and will be accurate, its not like quickbooks is going to miscarry a 1 or shift a decimal point on you.

Oh, I agree with that…you should have some sense of what order of magnitude numbers would be, etc.

I agree too that you need to know what the computer is doing, but at the admin/light bookkeeping level you might know to always be consistent in using “Office Supplies” as the category, say. It’s up to the accounting folks to wonder why a financial statement is out of whack and correct where Office Supplies feeds.

Off topic and apropos of a hijack, anyone whose approach is — “the bean counters will fix it” — and whose understanding of their job is — “the computer does that for me” — gets the same acclaim from me as do people who stop in the middle of an intersection and then turn on their left turn signal.

I’d prefer a paper cut on my eyeball!

In a small company, the “bean counters” are going to charge your boss $200 an hour to fix your mistakes - most of these firms don’t have “accountants” on staff - they have a guy they pay to come in every quarter and close the books. If you are the bookkeeper for a small company as part of your secretarial duties, your job is to enter the transactions correctly so the accountant has as little as possible to do when he closes the books.

On the other hand, I’ve met a number of CPAs who would prefer bookkeepers didn’t know any more than “class this as office supplies” because someone who knows too much may feel the sudden urge to adjust the bad debt accounts without understanding what the hell they are doing. Bookkeepping will mostly be “we wrote a check for rent, I enter the amount in correctly, make sure I have the corrent rent period in the system, and hit the button - and the cash account goes down the same amount.” The CPAs I know who deal with small businesses work with new bookkeepers to make sure that they are doing things the right way.

That was the point I was trying to make. Presumably the users don’t have access to be adjusting the set-up options for Quickbooks, as the bosses would like some assurance that what they set up is in effect across the board. No, I’m not advocating that users be non-thinking drones, but changes shouldn’t be allowed to be made ad hoc.