Project

General

Profile

Bookkeeping » History » Version 5

Kerilyn Bartley, 01/29/2019 04:13 PM

1 1 Jon Goldberg
# Bookkeeping
2
3
Megaphone Technology uses InvoiceNinja for A/R and Quickbooks Desktop for bookkeeping.
4
5
### Transfer client/invoice data from Invoiceninja
6
* Get clients from InvoiceNinja. IN settings » Import/Export » Export Clients to CSV.  Open in LibreOffice Calc.
7
* In Quickbooks, Lists menu » Add/Edit Multiple List Entries. List is "Customers".  Paste new clients in the "Name" and "Company Name" columns.
8 5 Kerilyn Bartley
* From the QB home screen, select "Create Invoices".  For now, it seems like manually retyping the invoices is the only option.  We just need client name, date, invoice #, item ("IT Consulting" or "Maintenance Plan"), and amount.
9 1 Jon Goldberg
10 4 Jon Goldberg
### Enter invoice payments into Quickbooks
11 1 Jon Goldberg
12 2 Jon Goldberg
* Note the last recorded payment in Quickbooks. You can find that by clicking on "Enter Payments" from the home screen, and clicking "back" once.
13 1 Jon Goldberg
* Pull up a list of payments in InvoiceNinja (Payments tab, sort by date)
14 2 Jon Goldberg
* Start entering the payments. Make sure to get the dates correct.
15 1 Jon Goldberg
16
17 4 Jon Goldberg
### Enter payments received as credits into Quickbooks
18
19 2 Jon Goldberg
* Note the last recorded payment in Quickbooks. You can find that by clicking on "Enter Payments" from the home screen, and clicking "back" once.
20 1 Jon Goldberg
* Pull up a list of payments in InvoiceNinja (Credits tab, sort by date, show Archived)
21 2 Jon Goldberg
* Start entering the payments. Make sure to get the dates correct.
22 1 Jon Goldberg
23 4 Jon Goldberg
### Cross-check: Compare outstanding client credits/debits in Quickbooks/Invoiceninja
24 1 Jon Goldberg
25
* QB's list is easily available by pulling up the customer center.
26
* You can see Invoiceninja balance from the [clients](https://invoices.megaphonetech.com/clients) screen.
27 4 Jon Goldberg
* This is also a good time to mark QB customers inactive that have been marked inactive in Invoiceninja. Double-click their name and check off "customer is inactive".
28 1 Jon Goldberg
29
### Record the deposits
30
31
Using either the bank statements or the "Checks Deposited" Google doc, you'll now group your payments into deposits.
32
* From the QB home screen, click "Record Deposits".
33
* Check off the first group of checks that were deposited together (note that you can slide your mouse over them to check them off faster).
34
* Confirm that the Payments Subtotal matches the bank statement, then Press OK.
35
* Enter the deposit date, then press "Save and New" until you're done.
36
* If your numbers are off, look at "Checks Deposited".
37
38
### Record accounts payable
39
40
Using the bank statements and/or the Amalgamated website, we can put all the payments into Quickbooks. Also a bit long/tedious.
41
42 4 Jon Goldberg
* From the home screen, click "Write Checks". Click on "Previous" to note the last transaction recorded in QB
43 1 Jon Goldberg
* Record payments on the bank statements.
44 3 Jon Goldberg
 * Make sure payments are categorized correctly.
45
 * When setting up a new vendor, don't do Quick Add; enter a default category for the payment.
46 1 Jon Goldberg
 * Make sure the date and check number is correct.
47 3 Jon Goldberg
 * The check number for debit card transactions is "DB". The check number for direct transfers from the bank account is "EFT".
48
 * Put any memos from the check into the memo field in QB.
49 1 Jon Goldberg
50
### Reconcile the bank acccount
51
52 4 Jon Goldberg
Bank reconciliation (aka "bank rec") is a cross-check to ensure that your ending balances in the bank account match that of Quickbooks. You do it once for each physical bank statement you have - though you can also just do it through any date if you know what the ending balance on that day was.
53 1 Jon Goldberg
54
* On the home screen, press the "Reconcile" button.
55
* Enter the Statement Date and the Ending Balance, press "Continue".
56
* Check off all the debits and credits that are on or before the statement ending date. If you're lucky, it'll match, and your difference will be $0.00.
57
** If not, go through the items one by one (or bifurcate!) and find the discrepancies and correct them.
58
59
### How to handle unusual transactions in Quickbooks:
60
61
* Tax refund: Make Deposits (Rec'd from: NYS Tax and Finance, From Account: Taxes, Memo: NYS Tax Refund, Payment Method: Check, Amount: $73)
62
* Bounced checks (to us, not from us: http://support.quickbooks.intuit.com/support/articles/HOW12221)