WELCOME!! GHOSTS AND GOBLINS ARE SC SCAR ARY. QUICKBOOKS DOESNT - - PowerPoint PPT Presentation
WELCOME!! GHOSTS AND GOBLINS ARE SC SCAR ARY. QUICKBOOKS DOESNT HAVE TO BE! Presented by our QuickBooks experts Becky Miller, Anne Becker, Lauren Brothen, and Christina Hess J AMES H AMLIN& C O .,P .C. CPAs & Business Advisors
JAMESHAMLIN&CO.,P .C.
CPAs & Business Advisors
1
2
3
below, go to Reports, Company & Financial, Profit & Loss Standard).
4
5
6
that you need to enter a new name when you are saving a memorized report.
save the report in a specific report group (Accountant, Banking, etc.)
7
8
9
10
When you receive payments from customers, you can either deposit each payment directly into a QuickBooks bank account, or you can group payments together to be moved to that account later. Depositing customer payments is part of your usual A/R workflow in QuickBooks Desktop. To see the complete list of workflows and other customer-related transactions, refer to Accounts Receivable workflows.
If you are depositing payments from you QuickBooks Payments account, check the batch totals before you make the deposit in the QuickBooks Payments (applicable to US only), under Activity and Reports > Deposits. When you have verified the batch totals OR if you don't have QuickBooks Payments account, proceed with the following steps:
11
then click Ok.
12
NOTE: The Payments to Deposit window, should open automatically. If it doesn't, it may be because your Undeposited Funds account is not turned on OR you have not received any payments yet. To open it, click the Payments button in the Make Deposits window.
where the payment will be deposited to.
you deposited. EXAMPLE: If there are payments for $1,077.50, $5,387.50 and $417.53 and you opted to deposit all of them on 12/15/2020 then your bank Register will show a $6,822.53 deposit for that
based on the amount of actual deposit to the bank account.
13
Enter a credit memo if a customer returns an item they already paid. A credit memo helps you keep track of the sale, payment and return of the item. The credit amount can be issued as a refund or retained in your customer account and applied to their next invoice.
register for the credit memo. You can use this credit as a payment for another transaction.
can select an invoice to which you want to apply this credit.
14
15
Option 1 : Through the Receive Payments window
Refund the amount to the customer.
16
Option 2 : Through the Write Checks window
17
18
19
Now that we’ve learned how to properly record payment and issue refunds and credit memos, let’s turn to the task of managing your accounts receivable. Fortunately, QuickBooks has many built in reports to help you!
Go to your “Reports” menu, then choose “Customers & Receivables”. You’ll find many options here. The first choice is the A/R Aging Summary. This report is very useful for quickly summarizing what your customers owe you. The money owed to you is sorted by how long it’s been outstanding so you can quickly focus in on those people that are using you as their bank.
20
The Average Days to Pay Summary report gives you the average days it takes the Customer to pay charges once they are invoiced. Double-click on the Customer to view a breakdown. The Average Days to Pay report lists each paid invoice with the number of days the Customer took to pay the charges. Then, it shows the average days to pay for each Customer or Job. This is a detailed version of the Average Days to Pay Summary report. The Accounts Receivable Graph shows how much your Customers owe you as of today, and how much is overdue by aging period. The pie chart shows each Customer and how much they owe relative to other Customers.
21
Those reports are nice, but my favorite is the Open Invoices report! The Open Invoices report lists unpaid invoices and statement charges grouped and subtotaled by Customer and
The Collections Report lists overdue invoices and statement charges by Customer and Job. This report includes Contact names and phone numbers so you can call each Customer to remind them of their overdue balances.
22
Customer with negative balance (Carts N’ More) Customer with zero balance but name still appears
Customer with balance that is not going to pay
(Deadbeat Corp.)
23
24
25
KEYS ACTION Ctrl+Del Delete the selected line in a transaction Ctrl+Ins Insert a blank detail line in a transaction Ctrl+N Create a new transaction or list item Ctrl+D Delete the current transaction or list item Ctrl+E Edit an item in an item list or in a register Ctrl+O Check in the write checks/cheques windows or in the check register: Use Ctrl+O to copy the check. You can then use Ctrl+V (paste) to create a copy of that check if you are in the check register. F5 Refresh list. You only see this if you are in multi-user mode when you have a list open. This will force QuickBooks to go back to the database server and retrieve the latest copy of the list. If multiple users are editing the list, this may be useful. Note that all open lists at the same time should be refreshed. Ctrl+H Transaction history (used inside a transaction)
Editing Transactions/List
26
Opening Windows/List
KEYS ACTION Ctrl+W Write Checks/Cheques Ctrl+Q To run a Quick Report, highlight an account, customer, or vendor then press Ctrl+Q to pull up the report. Ctrl+Y Transaction Journal (Used inside a transaction) Ctrl+J Customer Center Ctrl+A Chart of Accounts Ctrl+I Create Invoices Ctrl+L If the cursor is in a field that has a drop-down list, such as selecting the item in an invoice details line, this will open the list associated with that drop-down. Ctrl+U Use the item from the list that you have just opened using Ctrl+L. Ctrl+R Use Register Ctrl+G If you are in a register for an account, entering Ctrl+G will take you to the register for the "transfer" account associated with the line you have selected Ctrl+F Find F1 QuickBooks Help F2 or Ctrl+1 Product Information Screen F3 or Ctrl+2
edit a number of support and technical files that relate to QuickBooks operations. F4 QuickBooks Technical Support helper Esc or Ctrl+F4 Close Active window Ctrl+F6 Move to the next open window and make it active. Note: Some windows, such as the Accountant Center, does not allow this.
27
Maneuvering
KEYS ACTION + To increase the number in a form, such as a check/cheque number or invoice number, highlight the number you want to change.
Alt+S Save transaction Alt+N Save transaction and go to the next transaction Alt+P Go to the previous transaction Tab Go to the next field Shift+Tab Go to the prior field Up arrow (↑) Go to the previous line in a form Down arrow (↓) Go to the next line in a form Page Up Move to the previous page in a form area or report Page Down Move to the next page in a form area or report Ctrl+Page Up Move to the first item a list or register Ctrl+Page Down Move to the last item in a list or register Ctrl+Enter Record
28
Date Shortcuts
The following can be used while on the register or on any transaction list: KEYS ACTION + Advance to the next day
T Today W First day of the Week K Last day of the Week M First day of the Month H Last day of the Month Y First day of the Year [ (left bracket) Same day in previous week ] (right bracket) Same day in next week ; (semi colon) Same date last month ' (apostrophe) Same date next month Alt+Down arrow (↓) Opens the calendar for date selection (the small date calendar, not the “Calendar” feature)
JAMESHAMLIN&CO.,P .C.
CPAs & Business Advisors
29