Accounts Receivable/Payable/Cash Rec. - Page 2

  • Creator
    Topic
  • #185124
    hutchinson29
    Member

    I will be graduating in the spring of 2015 and I am wondering how much GPA matters for accounts receivable, accounts payable, and cash rec. type of positions. It looks like a lot of those only require an associates degree. I will be getting my bachelors with about 150 credits. Obviously I would eventually like to move up from a position like that but I only have a 2.6 GPA (2.9 accounting) (C’s in core classes not related to business or accounting). I work a lot of hours which definitely hinders the amount of time I am able to put into school. I wake up at 6am everyday and pretty much do my Peachtree homework all day long to get it done on time in between work and then barely have time to study for intermediate or tax. I go into some of the intermediate tests blind and get about the class average because I have a fairly good understanding of the normal balances and the basics which essentially is the most important in my humble opinion. I will probably end up getting a C in intermediate II this semester though because it is much harder than intermediate I. I don’t think anyone leaves college knowing all the parts of the pension worksheet even if they got an A in the class. A person with a C that understands how accounting works is able to apply their education more than someone who just memorized the journal entries and the pension worksheet without actually understanding the material. I have experience with petty cash, payables and receivables, month-end close reconciliations, other reconciliations, advanced excel, and my boss told me I will be reconciling bank statements soon. I’m completely revamping the excel spreadsheets at a different small business and making their invoices simpler and easier to use. We were wasting time inputting data into 7 different spreadsheets when I first started working there and now we put it into 2. The boss had us emailing her files every night because she wanted to have them in an email for backup in case the computer crashed. I made them start using Google Drive for that and I made them start scanning the checks and organizing them by month in folders because there was incomplete data on some of the invoices and we needed records for the checks. My first few years of college I was involved in athletics and probably didn’t take school as seriously as I should have and I wasn’t an accounting major at the time either. With a lot of the classes I felt like I would have been ‘stepping on the gas with my tires in the mud’ when it came to learning. I felt like if I put in the work to get an A in biology and and business management, which is a common sense class, that I would have just been memorizing things that don’t have real world practicality. When I switched to accounting, I decided to stop playing hockey at the school because it took up 20 hours per week and then weekend travel on top of that, and decided to work more and get off my parents bills. That was my own choice no one made me do it. Now essentially I have less time than when I was involved in athletics because I switched majors late and have been taking 3/4 accounting courses per semester and have been working a lot. Speed is definitely my crutch as well. I do not need to review the information lots of times to understand it but it takes me a little longer than most people to get through the information even just one time. I don’t think my GPA is a result of my lack of work ethic, in fact I think its because I am maybe too ambitious and put myself in situations that make things difficult. So basically, for those kind of positions will they even ask for my GPA? I think it would be a great place to start and learn more processes and possibly move up in a company. Public accounting is unrealistic with my GPA. I plan on getting my CPA to advance my career and after that noone will probably ask for my GPA.

Viewing 15 replies - 16 through 30 (of 30 total)
  • Author
    Replies
  • #548026
    hutchinson29
    Member

    Well, below is my experience. What kinds of jobs did you have offers for, How many letters do you need? And did GPA come up in the interview and if so how did you handle it?

    Job 1:

    • Responsible for bookkeeping in Excel including customer payments and charges, payroll, customer information, and other information as requested by management

    • Revamped the company’s entire Excel spreadsheet system by creating well organized and easy to read spreadsheets, inserting formulas, and implementing pivot tables and data validation lists

    • Payroll duties included revamping a payroll spreadsheet and implementing a new timesheet system as well as calculating all withholding

    • Revamped the company’s excel invoices and statements

    • Implemented a payment log in excel to record all payments that get transferred to invoices

    • Played a central role in various business practices including determining the locations of customers to decide if the company should expand to a new location and the implementation of Google Drive as a means of backing up files

    • Created new folders and paths within Google Drive to create ease in finding files

    • Implemented the scanning of daily checks and folder paths to store the checks by month

    • Assist customers in person and on the phone in recording payments and answering questions

    Job 2:

    • Assist the staff accountants with various finance functions including basic bookkeeping, payables and receivables, balancing petty cash accounts, customer payments, past due collection attempts, health insurance deductions, monthly reconciliations, and other account reconciliations

    • Reconciliations include an audit of journal entries in the payment software system as well as importing data into Excel and using the find function to find transactions, dividing unreconciled amounts by the amount of common transactions, reviewing the daily financial reports, examining bank statements, referencing the chart of accounts, comparing data from multiple systems, correcting formulas in Excel, and other means suitable for reconciling the accounts

    • Reference the chart of accounts when inputting and auditing journal entries not only for the account numbers but also for other numbers related to the transactions

    • Open mail to record payments via check, scan checks and file appropriately, and receive petty cash information with receipts to input into Excel

    • Assist the staff accountants with miscellaneous projects including calculating reimbursement costs for employees with missing receipts, information updates to submit to other departments, and other miscellaneous projects

    • Revamped a record of expenditures spreadsheet to calculate expenditures for an entire summer by including circular formulas from spreadsheet to spreadsheet, data validation lists, and if formulas

    • Use Excel, Word and Outlook to facilitate office communication including innovation to the systems

    • Leave comments in Excel to communicate information to the staff accountants

    • Set-up rules in Outlook to automatically move emails from certain senders to specific folders

    • Respond to voicemails, emails, and phone calls to assist customers

    My boss at job 2 also said that I will be reconciling bank statements in May

    Activities

    Men’s Varsity Ice Hockey 2010 – 2013 / 3 Seasons

    • Member of the 2010 – 2011 Minnesota Intercollegiate Athletic Conference playoff runner-ups

    • Practiced 20+ hours per week in addition to weekend travel while managing a full course load and completing a double major

    Accounting Club October 2013 – Present / 0 Years, 7 Months

    • Participation at various meetings

    Thank you all, very much.

    #548008
    kahtwoloo
    Participant

    Good luck with that. I graduated in May 2012 with 143 credits. My plan was get the last 7 credits during the summer semester then knock the exam out in 6 months. That obviously didn't work out if look at my scores. I've been trying to land the exact same types of jobs as you with 0 luck. I've had almost 30 interviews this past year and every one of them goes exactly the same; “We're really looking for someone with experience” or “I'm sure you're great but I'm worried that if we hire you, you'll just take off after you pass your exams in a year.” I don't really want to leave the CPA exam stuff off my resume because then I'll have a gaping 2 year hole on my resume with no explanation except for a 2 month temp job. Hopefully things work out better for you.

    BEC-51,71,70,77
    AUD-50,62,68 (retake july)
    REG-55
    FAR-15(didnt study)

    #548028
    kahtwoloo
    Participant

    Good luck with that. I graduated in May 2012 with 143 credits. My plan was get the last 7 credits during the summer semester then knock the exam out in 6 months. That obviously didn't work out if look at my scores. I've been trying to land the exact same types of jobs as you with 0 luck. I've had almost 30 interviews this past year and every one of them goes exactly the same; “We're really looking for someone with experience” or “I'm sure you're great but I'm worried that if we hire you, you'll just take off after you pass your exams in a year.” I don't really want to leave the CPA exam stuff off my resume because then I'll have a gaping 2 year hole on my resume with no explanation except for a 2 month temp job. Hopefully things work out better for you.

    BEC-51,71,70,77
    AUD-50,62,68 (retake july)
    REG-55
    FAR-15(didnt study)

    #548010
    samdiegoCPA
    Member

    Whilst job searching, I rarely saw any GPA requirements for companies. Personally, I think it's stupid for companies to require any scores. I only had a 3.0 GPA and received a B or C in most in my accounting classes, yet I am really good at understanding it. I'm just not a good student. A lot of my friends were 4.0 students, yet are terrible spellers and bad at grammar, air their dirty laundry on FB, or are just completely incompetant.

    I had a meeting with a recruiter at Deloitte and she told me once I have my CPA, the GPA will never matter to anyone.

    @kahtwoloo Exact same position I was in a year ago. 3 yrs accounting experience, 3 years gap while going to school and not working, then passed AUD and was applying for jobs. Half said overqualified, half said need more experience. I'm still scared of how I will be perceived when getting my next job (no CPA at my current employment, so I won't get licensed until I get a new job with a CPA)

    AUD: 84
    REG: 84
    BEC: 79
    FAR: 83

    #548030
    samdiegoCPA
    Member

    Whilst job searching, I rarely saw any GPA requirements for companies. Personally, I think it's stupid for companies to require any scores. I only had a 3.0 GPA and received a B or C in most in my accounting classes, yet I am really good at understanding it. I'm just not a good student. A lot of my friends were 4.0 students, yet are terrible spellers and bad at grammar, air their dirty laundry on FB, or are just completely incompetant.

    I had a meeting with a recruiter at Deloitte and she told me once I have my CPA, the GPA will never matter to anyone.

    @kahtwoloo Exact same position I was in a year ago. 3 yrs accounting experience, 3 years gap while going to school and not working, then passed AUD and was applying for jobs. Half said overqualified, half said need more experience. I'm still scared of how I will be perceived when getting my next job (no CPA at my current employment, so I won't get licensed until I get a new job with a CPA)

    AUD: 84
    REG: 84
    BEC: 79
    FAR: 83

    #548012
    hutchinson29
    Member

    Is my experience going to make a difference?

    #548032
    hutchinson29
    Member

    Is my experience going to make a difference?

    #548014
    hutchinson29
    Member

    While the kinds of positions I listed generally don't have GPA requirements, that doesn't mean my competition wouldn't have a higher GPA than me and thus have an advantage from that aspect.

    #548034
    hutchinson29
    Member

    While the kinds of positions I listed generally don't have GPA requirements, that doesn't mean my competition wouldn't have a higher GPA than me and thus have an advantage from that aspect.

    #548016
    acamp
    Participant

    THIS: I have experience with petty cash, payables and receivables, month-end close reconciliations, other reconciliations, advanced excel, and my boss told me I will be reconciling bank statements soon. I'm completely revamping the excel spreadsheets at a different small business and making their invoices simpler and easier to use. We were wasting time inputting data into 7 different spreadsheets when I first started working there and now we put it into 2. The boss had us emailing her files every night because she wanted to have them in an email for backup in case the computer crashed. I made them start using Google Drive for that and I made them start scanning the checks and organizing them by month in folders because there was incomplete data on some of the invoices and we needed records for the checks.

    NOT THIS: I don't think anyone leaves college knowing all the parts of the pension worksheet even if they got an A in the class. A person with a C that understands how accounting works is able to apply their education more than someone who just memorized the journal entries and the pension worksheet without actually understanding the material.

    Focus on what you do well, don't try to marginalize your weak areas. Plenty of people have work + school and manage to gain an understanding and get A's in their classes.

    Ninja + Wiley Test Bank: [FAR - 81] [REG - 76] [BEC - 88] [AUD - 73](doh!)

    Becker Videos: [AUD - 82]

    California CPA

    #548036
    acamp
    Participant

    THIS: I have experience with petty cash, payables and receivables, month-end close reconciliations, other reconciliations, advanced excel, and my boss told me I will be reconciling bank statements soon. I'm completely revamping the excel spreadsheets at a different small business and making their invoices simpler and easier to use. We were wasting time inputting data into 7 different spreadsheets when I first started working there and now we put it into 2. The boss had us emailing her files every night because she wanted to have them in an email for backup in case the computer crashed. I made them start using Google Drive for that and I made them start scanning the checks and organizing them by month in folders because there was incomplete data on some of the invoices and we needed records for the checks.

    NOT THIS: I don't think anyone leaves college knowing all the parts of the pension worksheet even if they got an A in the class. A person with a C that understands how accounting works is able to apply their education more than someone who just memorized the journal entries and the pension worksheet without actually understanding the material.

    Focus on what you do well, don't try to marginalize your weak areas. Plenty of people have work + school and manage to gain an understanding and get A's in their classes.

    Ninja + Wiley Test Bank: [FAR - 81] [REG - 76] [BEC - 88] [AUD - 73](doh!)

    Becker Videos: [AUD - 82]

    California CPA

    #548018
    hutchinson29
    Member

    True, acamp. Thanks for the input.

    #548038
    hutchinson29
    Member

    True, acamp. Thanks for the input.

    #548020
    nicole2035
    Member

    no one cares what your GPA is for the most part, they just care you have an accounting degree. You could easily get an AR, AP job, because i find a lot of the people in those departments (depending on size etc) don't have accounting degrees. They're doing the same type of entries over and over, and don't need much ‘judgement' on anything. You being older i think makes you more attractive as a candidate. I promise you, no employer will ask your GPA. For the most part being a staff accountant is trainable, it all depends on if you can find a company willing to do that, and i think you can. There are people in my accounting department that got trained into the position, and they did their job awesome and u never noticed they didn't have the degree till it came small minor things

    #548040
    nicole2035
    Member

    no one cares what your GPA is for the most part, they just care you have an accounting degree. You could easily get an AR, AP job, because i find a lot of the people in those departments (depending on size etc) don't have accounting degrees. They're doing the same type of entries over and over, and don't need much ‘judgement' on anything. You being older i think makes you more attractive as a candidate. I promise you, no employer will ask your GPA. For the most part being a staff accountant is trainable, it all depends on if you can find a company willing to do that, and i think you can. There are people in my accounting department that got trained into the position, and they did their job awesome and u never noticed they didn't have the degree till it came small minor things

Viewing 15 replies - 16 through 30 (of 30 total)
  • The topic ‘Accounts Receivable/Payable/Cash Rec. - Page 2’ is closed to new replies.