Q. Your long term goal Q. Fixed income terminology
Reconciliation Interview Questions
380 reconciliation interview questions shared by candidates
What is split stock ?
bonds,irr,npv, derivatives, old company and process
What were you doing once you finished your last accounting job? I expected. But little hesitant whether 2 talk about warehouse job as General labourer.
Question 1: What is the of sum of Amount for each BankDate, Account, and TransactionName in dbo.DailyBankData? Please order results by Account. Question 2: The ACH Credit records on 3/3/2025 and 3/4/2025 represent funding coming in from our customers to make payments on their behalf – multiple payment records are included a single ACH Credit and based on the designated “SourceAccount” field on dbo.Payments. The funding in this exercise will appear in the dbo.DailyBankData table on the following date from the PaymentDate in dbo.Payments. What records from the dbo.Payments table were part of the ACH Credit with TransactionId = 21117008? Please show the PaymentDate, PaymentNumber, Type, and PaymentAmount in your results. Question 3: The ReferenceNumber field on dbo.DailyBankData represents the check number, if applicable, for the clearing event. Which payments with a Type of Check, based on the dbo.DailyBankData table are still outstanding and have not cleared? Please show the following fields in your results: PaymentDate, PaymentNumber, CheckNumber, PaymentAmount, SourceAccount. Question 4: Which payments share the same CheckNumber in the dbo.Payments table? In your results, please show PaymentDate, PaymentNumber, Type, SourceAccount, PaymentAmount, and CheckNumber Question 5: Using your query from Question 4, please build upon it to answer the following question. What date did these checks for these payments clear in dbo.DailyBankData? In your results, please show PaymentDate, PaymentNumber, Type, SourceAccount, PaymentAmount, CheckNumber, and BankDate. Question 6: In this exercise VCC payments funded to 3 rd party who then processes those payments. The funding happens via an Outgoing Wire transaction from the same account as the SourceAccount for each payment on dbo.Payments. The Outgoing Wire in dbo.DailyBankData will be an aggregated amount of the PaymentAmount by SourceAccount and PaymentDate. How many payments from dbo.Payments were included in each Outgoing Wire, and how many unique OriginatingPaymentNumber records were included in each Outgoing Wire? Please include the following fields: BankDate, TransactionId, Account (DailyBankData), Amount (DailyBankData), Payments (number of payments), OriginatingPayments (number of unique Originating Payment Numbers). Question 7: Using your query from Question 6, please build upon it to answer the following question. What are the PaymentNumbers and PaymentAmounts for the Outgoing Wire that cleared the bank on 3/5/2025? Please include the following fields: BankDate, TransactionId, Account (DailyBankData), Amount (DailyBankData), PaymentNumber, PaymentAmount
the question related to the job role
Tell me about yourself? Your achievements? How you think you can make a difference?
Whats your long term goal
My experience and education background
What do you do in your spare time.
Viewing 281 - 290 interview questions