堪培拉 全修班 27/11/2018 作业

JennyXiong2018

课堂作业：Payroll tax reconciliation的注意事项
payroll tax rate 在一年内也许会变化，这时要按变化的时间来分开进行Reconciliation。
E.g.: 2018年7月-2018年12月是rate 1, 2019年1月-2019年6月是rate 2, 即在1月份时payroll tax rate发生了变化，把一年的reconciliation分开为两个时间段：2018年7月-2018年12月按rate 1来reconciliation, 2019年1月-2019年6月是rate 2来reconciliation。两个时间段合起来仍是一年。

Interview question:

Jenny:face to face interview3,technical based question5,15,25,35,behaviour questions8,18

1. face to face interview 3: What do you usually do in your current/last job?

Translation: How does your previous job experience relate to the job I’m looking to fill? In answering this question, you want to show the interviewer that, once giving the position, you’ll be able to achieve success based on your past experience.

Answer:

When answering, focus on you’re the tasks required for the last job that is applicable to the position you’re interviewing for, how your skills apply to both positions (past and present) and how you’ll be able to hit the ground running if given the position you’re interviewing for. Make sure to give examples to back up your claims.

outline:

1. Briefly describe current job position

2. List JOB QUALIFICATIONS

3. Summarize your work achievements

Attention:

1. Focus on results.  Don't just listing your job duties.

2. Customize for the position. Don’t try to memorize a script.

3. Be concise. Don’t try to describe absolutely everything that you do. Nobody wants to hear about TPS reports. Focus on the highlights that this particular interviewer will care about.

2. Technical based question 5: What are the policies and guidelines on AP in your current company?

Focus:

Our journalistic policies are central to our mission.

Material Source:

The manager is responsible for vetting the material and making sure it meets AP guidelines. The manager must know the identity of the source and is obligated, like the reporter, to keep the source's identity confidential. Only after they are assured that the source material has been vetted should editors allow it to be transmitted.

CORRECTIONS/CORRECTIVES:

Staffers must notify supervisory editors as soon as possible of errors or potential errors, whether in their work or that of a colleague. Every effort should be made to contact the staffer and his or her supervisor before a correction is moved.

When we're wrong, we must say so as soon as possible. When we make a correction in the current cycle, we point out the error and its fix in the editor's note. A correction must always be labeled a correction in the editor's note. We do not use euphemisms such as "recasts," "fixes," "clarifies" or "changes" when correcting a factual error.

3. Technical based question 15: What are your largest balance sheet accounts?

Of the various types of items a company owns; accounts receivables, inventory, PP&E and intangibles are generally the four largest accounts in the asset side of a balance sheet.
As a consequence, a strong balance sheet is built on the efficient management of these major asset types and a strong portfolio is built on knowing how to read and analyze financial statements.

4. Technical based question 25: Do you know how to do calculation inside of Pivot Table?

• Select a cell in the pivot table, and on the Excel Ribbon, under the PivotTable Tools tab, click the Options tab (Analyze tab in Excel 2013).
  
• In the Calculations group, click Fields, Items, & Sets, and then click Calculated Field.
  

file:///C:/Users/Jenny/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png

• Type a name for the calculated field, for example, RepBonus.
  
• In the Formula box, type =Total * 3%
  
• Click Add to save the calculated field and click Close.
  

file:///C:/Users/Jenny/AppData/Local/Temp/msohtmlclip1/01/clip_image002.png

• The RepBonus field appears in the Values area of the pivot table, and in the field list in the PivotTable Field List.file:///C:/Users/Jenny/AppData/Local/Temp/msohtmlclip1/01/clip_image004.png
  

file:///C:/Users/Jenny/AppData/Local/Temp/msohtmlclip1/01/clip_image005.png

5. Technical based question 35: What are you supposed to do if you processed an invoice against wrong GL code?

GL code = general ledger code

If the A/P invoice hasn’t been paid, you can adjust or reverse the A/P invoice. If you are only changing the G/L distribution account on the invoice: Enter 0.00 as the adjustment amount. To "delete" or "adjust out" or "zero out" an invoice: Enter the balance of the invoice as a negative amount. On the Lines tab: For G/L Account, enter the original incorrect General Ledger account as a negative amount. And then enter the correct G/L account with a positive amount. (The net result should be zero)

If the A/P invoice has been paid, can’t change for this time. Notify the supplier about the mistake and correct the invoice that’s filed. Make adjustment for the next time.

6. Behaviour Questions 8: Can you work independently when required?

What does it mean to be independent?

·        Becoming self-aware, self-monitoring and self-correcting;

·        Knowing what you need to do;

·        Taking the initiative rather than waiting to be told what to do;

·        Doing what is asked to the best of your ability, without the need for external prodding, and working until the job is completed;

·        Learning to work at a pace that you can sustain;

·        Taking ownership of your mistakes without looking for excuses; and

·        Refusing to let self-doubt or negative emotions due to negative past experiences take you off course.

Highlight the working skills that help achieve independence.

·        Organizational skills. ...

·        Multitasking ability. ...

·        Discipline. ...

·        Communication skills. ...

·        Ability to compromise. ...

·        Flexibility. ...

·        Ability to deal with rejection and not to take it personally.

Different situations in the workplace may require independence while others will need the efforts of an entire team. However, you should take caution in exaggerating your abilities to work independently or in a group, as this may backfire.

7. Behaviour Questions 18: Tell me about a situation where you had to solve a difficult problem.

The interviewer is likely looking for a general problem-solving orientation to your personality. For many jobs, the hiring manager is also looking for a proven track record in addressing the types of challenges that are common in the role.

Do prepare a few stories about your greatest problem-solving hits. Think of the most impressive challenges that you’ve overcome, the most creative approaches, the solutions that made the biggest difference for the organization. These can be job-specific problems or higher-level strategic issues.