Project

General

Profile

Bookkeeping » History » Version 30

Jon Goldberg, 04/08/2023 04:57 PM

1 16 Jon Goldberg
{{last_updated_at}} by {{last_updated_by}}
2
3 1 Jon Goldberg
# Bookkeeping
4
5
Megaphone Technology uses InvoiceNinja for A/R and Quickbooks Desktop for bookkeeping.
6
7 20 Jon Goldberg
### Transfer client data from Invoiceninja
8 10 Jon Goldberg
* Get clients from InvoiceNinja. IN **Settings » Import/Export » Export Clients to CSV**.  Open in LibreOffice Calc.
9
* In Quickbooks, **Lists menu » Add/Edit Multiple List Entries**. List is **Customers**.  Paste new clients in the *Name* and *Company Name* columns.
10 19 Jon Goldberg
 * Set the list *View* to **All Customers**.  Otherwise it's not clear which Invoiceninja clients are new vs. already archived in Quickbooks.
11 1 Jon Goldberg
 * *Work to Reassign* isn't a real client, don't transfer to Quickbooks.
12 20 Jon Goldberg
13
14 29 Jon Goldberg
#### Automated invoice/credit/payment import
15
This is new in 2023. Manual steps are in older versions of this wiki page.
16 28 Jon Goldberg
* Note the last recorded invoice in Quickbooks. You can find that by clicking on **Create Invoices** from the home screen, and clicking "back" once.
17 1 Jon Goldberg
* Go to Invoiceninja **Reports** tab. Select *Type* of **Invoice**, the date range of invoices we need, and press **Export** (to CSV).
18 27 Jon Goldberg
* Rename the file to `invoices.php` and place it in the `invoiceninja-to-iif/input` folder.
19
* Run `invoices.php`.
20
* Import the resulting IIF file into Quickbooks.
21 2 Jon Goldberg
22 28 Jon Goldberg
Do the same for payments ("Record Payments" in QB, file is `payments.csv`, run `payments.php`).
23
Same for credits - but manually add the `Date` field to `credits.csv` in ISO format.
24 1 Jon Goldberg
25 4 Jon Goldberg
### Cross-check: Compare outstanding client credits/debits in Quickbooks/Invoiceninja
26 1 Jon Goldberg
27
* QB's list is easily available by pulling up the customer center.
28 14 Jon Goldberg
* You can see Invoiceninja balance from the [clients](https://invoices.megaphonetech.com/clients) screen.  **Note:** If the client has a *credit*, this will NOT show up on the client screen (this may be a bug).  If the numbers don't match Quickbooks, click into the client to look for a credit.
29 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".
30 1 Jon Goldberg
31 30 Jon Goldberg
### Record the deposits - Checks
32 1 Jon Goldberg
33 30 Jon Goldberg
Using the bank statements, you'll now record deposits.
34
**Note:** The vast majority of checks are e-deposited, so each "deposit" is a single check.
35 1 Jon Goldberg
* From the QB home screen, click "Record Deposits".
36 30 Jon Goldberg
* Sort by payment method, we're only looking at *Checks*.
37
* Put a checkbox next to the first check, press **OK**.
38
* Find the check on the bank statement (will be listed as *Mobile Check Deposit*), enter the deposit date in Quickbooks.
39
 * Sometimes one check pays multiple invoices, so you need to put them in the same deposit. 
40
* Press "Save and New", repeat until you're done.
41 13 Jon Goldberg
* If your numbers are off, look at "Checks Deposited".
42 30 Jon Goldberg
43
### Record the deposits - ACH
44
45
Same as above, but we're looking at payment method of *ACH*.
46
ACH payments will have the name of the organization on the bank statement, and usually "bill.com" as well.
47 7 Jon Goldberg
48 24 Jon Goldberg
### Record the deposits - Wire transfers
49 7 Jon Goldberg
* From the QB home screen, click "Record Deposits".
50 24 Jon Goldberg
* Locate wire transfers on the bank statements.
51
* Check off the corresponding payment in Quickbooks.
52
* On the next blank line, set the *Account* to "Bank Service Charges* and enter a *negative* amount that equals the service charge.
53 1 Jon Goldberg
* Enter the deposit date from the bank statement, then press "Save and New" until you're done.
54 15 Jon Goldberg
55
### Record the deposits - PayPal
56 1 Jon Goldberg
* From the QB home screen, click "Record Deposits".
57 25 Jon Goldberg
* Log into Paypal.com, go to **Activity > All Reports** menu, then **Activity Download**.
58 1 Jon Goldberg
* Run a report of type **Balance Affecting** for the appropriate time period, download as a CSV.
59 15 Jon Goldberg
* Check off the corresponding group of payments in Quickbooks.
60
* 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.
61
62 26 Jon Goldberg
### Record the deposits - credit card and ACH (Stripe) and other ACH (bill.com etc.
63 7 Jon Goldberg
* From the QB home screen, click "Record Deposits".
64 24 Jon Goldberg
* Log into Stripe.com, go to *Payments* and export all payments.
65
* Open the export in your spreadsheet software and create a column called "Net" that's Total - fee.
66
* 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.
67
* Check off the corresponding group of payments in Quickbooks.
68
* 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.
69 1 Jon Goldberg
* Enter the deposit date from the bank statement, then press "Save and New" until you're done.
70 26 Jon Goldberg
* *Other bill payments* Some clients send money to us that bypasses Stripe, and is generally for the full amount.  Currently they'll show up as bill.com, Building One America, and Skytruth.  Record these the same as other ACH payments, but there are no banking fees.
71 1 Jon Goldberg
72
### Record accounts payable
73
74
Using the bank statements and/or the Amalgamated website, we can put all the payments into Quickbooks. Also a bit long/tedious.
75
76 4 Jon Goldberg
* From the home screen, click "Write Checks". Click on "Previous" to note the last transaction recorded in QB
77 1 Jon Goldberg
* Record payments on the bank statements.
78 3 Jon Goldberg
 * Make sure payments are categorized correctly.
79
 * When setting up a new vendor, don't do Quick Add; enter a default category for the payment.
80 1 Jon Goldberg
 * Make sure the date and check number is correct.
81 3 Jon Goldberg
 * The check number for debit card transactions is "DB". The check number for direct transfers from the bank account is "EFT".
82
 * Put any memos from the check into the memo field in QB.
83 1 Jon Goldberg
84
### Reconcile the bank acccount
85
86 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.
87 1 Jon Goldberg
88
* On the home screen, press the "Reconcile" button.
89
* Enter the Statement Date and the Ending Balance, press "Continue".
90
* 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.
91
** If not, go through the items one by one (or bifurcate!) and find the discrepancies and correct them.
92
93
### How to handle unusual transactions in Quickbooks:
94
95
* Tax refund: Make Deposits (Rec'd from: NYS Tax and Finance, From Account: Taxes, Memo: NYS Tax Refund, Payment Method: Check, Amount: $73)
96
* Bounced checks (to us, not from us: http://support.quickbooks.intuit.com/support/articles/HOW12221)