Project

General

Profile

Bookkeeping » History » Version 8

Jon Goldberg, 03/09/2020 05:34 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 6 Kerilyn Bartley
* Note the last recorded payment in Quickbooks. You can find that by clicking on "Receive 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
* Start entering the payments. Make sure to get the dates correct.
15
16 4 Jon Goldberg
### Enter payments received as credits into Quickbooks
17
18 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.
19 1 Jon Goldberg
* Pull up a list of payments in InvoiceNinja (Credits tab, sort by date, show Archived)
20 2 Jon Goldberg
* Start entering the payments. Make sure to get the dates correct.
21 1 Jon Goldberg
22 4 Jon Goldberg
### Cross-check: Compare outstanding client credits/debits in Quickbooks/Invoiceninja
23 1 Jon Goldberg
24
* QB's list is easily available by pulling up the customer center.
25
* You can see Invoiceninja balance from the [clients](https://invoices.megaphonetech.com/clients) screen.
26 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".
27 1 Jon Goldberg
28 7 Jon Goldberg
### Record the deposits - checks
29 1 Jon Goldberg
30
Using either the bank statements or the "Checks Deposited" Google doc, you'll now group your payments into deposits.
31
* From the QB home screen, click "Record Deposits".
32 8 Jon Goldberg
* Each electronic deposit shows up individually - so check off a single payment and press "Save and New".  Repeat until all payments are recorded.
33 7 Jon Goldberg
34
### Record the deposits - credit card and ACH
35
* From the QB home screen, click "Record Deposits".
36
* Log into Stripe.com, go to *Payments* and export all payments.
37
* Open the export in your spreadsheet software and create a column called "Net" that's Total - fee.
38
* Check the bank statement for payments from Stripe.com.  They'll batch multiple payments together, so find the payments on the Stripe export whose "net" adds up to the amount on the statement.
39
* Check off the corresponding group of payments in Quickbooks.
40
* On the next blank line, set the *Account* to "Bank Service Charges* and enter a *negative* amount that equals the service charge.  Note that all Quickbooks fields allow you to do arithmetic, so you can put in the amount from the statement minus the total of payments.
41
* Enter the deposit date from the bank statement, then press "Save and New" until you're done.
42
43
### Record the deposits - Wire transfers
44
* From the QB home screen, click "Record Deposits".
45
* Locate wire transfers on the bank statements.
46
* Check off the corresponding payment in Quickbooks.
47
* On the next blank line, set the *Account* to "Bank Service Charges* and enter a *negative* amount that equals the service charge.
48
* Enter the deposit date from the bank statement, then press "Save and New" until you're done.
49 1 Jon Goldberg
50
### Record accounts payable
51
52
Using the bank statements and/or the Amalgamated website, we can put all the payments into Quickbooks. Also a bit long/tedious.
53
54 4 Jon Goldberg
* From the home screen, click "Write Checks". Click on "Previous" to note the last transaction recorded in QB
55 1 Jon Goldberg
* Record payments on the bank statements.
56 3 Jon Goldberg
 * Make sure payments are categorized correctly.
57
 * When setting up a new vendor, don't do Quick Add; enter a default category for the payment.
58 1 Jon Goldberg
 * Make sure the date and check number is correct.
59 3 Jon Goldberg
 * The check number for debit card transactions is "DB". The check number for direct transfers from the bank account is "EFT".
60
 * Put any memos from the check into the memo field in QB.
61 1 Jon Goldberg
62
### Reconcile the bank acccount
63
64 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.
65 1 Jon Goldberg
66
* On the home screen, press the "Reconcile" button.
67
* Enter the Statement Date and the Ending Balance, press "Continue".
68
* 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.
69
** If not, go through the items one by one (or bifurcate!) and find the discrepancies and correct them.
70
71
### How to handle unusual transactions in Quickbooks:
72
73
* Tax refund: Make Deposits (Rec'd from: NYS Tax and Finance, From Account: Taxes, Memo: NYS Tax Refund, Payment Method: Check, Amount: $73)
74
* Bounced checks (to us, not from us: http://support.quickbooks.intuit.com/support/articles/HOW12221)