QuickBooks

• These notes present usual scenarios, either using a smartphone app or a desktop computer, depending on what is more practical.
• CAPITAL LETTERS indicate menu or fields in Quickbooks Online.
• Menus are indicated with “>” for the next steps seen in QB or portals themselves.
• In general, use TAB to confirm entry, rather than ENTER.
• Always add the names of suppliers or donors in filenames.
• Suppliers are those paid: companies, Admin, Sisters, Personnel.
• Donors are those who pay: Students, Guests, Benefactors, etc.
• Make sure the right accounts are always used. Some Quickbook Account Numbers are omitted, as they may change once in a while.
• When an instruction states to do some step(s) “as usual”, please refer to other sections of this guide.

To see Statement of Accounts: >Documenti >Conti Correnti: the monthly Statements are shown for possible download, but only of Accounts with movements on a specific month.

1. Create a new record for students as they arrive: >Donors & leads >New donor
2. >Title: “Fr.” (with period), >First Name, >Last Name; >Display name as: “Fr Juan de la Cruz” should automatically appear, otherwise select it from the dropdown arrow
3. >Save
4. NOTE: for USD, add ” – USD” after the family name: “Fr. Juan de la Cruz – USD”
5. NOTE: For Priest’s BILLING ADDRESS >STREET: put the Diocese (and for non-Filipinos, add a dash and the country, like: “Bangkok – Thailand”)

1. They may be entered directly when >+New >Sales receipt >donor: write the first name only
2. >+Add new (this option appears right under the first name you are typing)
3. >Currency: change if needed into USD, CHF, GBR, etc.
4. +Details
5. >Last name: if currency is not EUR, add to the family name ” – USD”, ” – CHF”, etc.
6. >Display name as: should include first name, family name and the currency if not EUR (use dropdown arrow if needed)
7. >Email (if available)
8. >Payment and billing >This donor pays me with: (here the currency may still be changed, if not done so earlier)
9. >Save

1. They may be entered directly when >+New >Expense >Payee: write the first name only
2. >+Add new (this option appears right under the first name you are typing)
3. >Currency: change if needed into USD, CHF, GBR, etc.
4. +Details
5. >Last name: if currency is not EUR, add to the family name ” – USD”, ” – CHF”, etc.
6. >Display name as: should include first name, family name and the currency if not EUR (use dropdown arrow if needed)
7. >Email (if available)
8. >I pay this supplier with: (here the currency may still be changed, if not done so earlier)
9. >Save
10. 10. NOTE: for Priests as Suppliers (e.g., for excursion expenses through them), add a space and a dash (” -“) after the family name.

EXPENSES – from Cash on Hand
CHEQUES – bonifico, giroconto and cash withdrawals

1. >+New >Sales receipt
2. Donor: search for the name (or if none, yet, >Add, then put name and email address)
3. Sales Receipt date: when the amount was received.
4. Sales Receipt no.: should automatically follow the year’s series; otherwise check for the latest series number in QB >Invoicing >All Sales (only Invoices and Sales Receipts are assigned series numbers, which restart at 001 on January 1 each year).
5. Payment Method: usually Cash or Direct Debit to IOR (refer to similar transactions in the past).
6. Deposit to: either bank account where the payment was deposited, or if cash, to Undeposited Funds (for Deposit later to Cash on Hand).
7. Product/Service: usually “OPERATIONS (Receipt/Invoice)”, including for overnight stays and outright donations. But for student’s board and lodging, select “RECEIPT – Student Funds (agencies for b/l, tuition, allowances, INCLUDING MIXED for student and PCF)” – this credits the amount to “4500000 PASS-THROUGH INCOME” which in turn will be used to pay student Invoices (except for RCAM students, who use “2201000 NON-CURRENT LIABILITIES: ROMAN CATHOLIC ARCHBISHOP OF MANILA”.
8. Description: e.g., “Donation” (and dates if for overnight stays), or “Scholarship for Fr. Juan de la Cruz”
9. Rate: total amount to be given
10. Message displaced on statement: copy and paste from Description (above) so that it appears later in the Donor’s list of Invoices.
11. Save and Send.

1. Search for the student as Donor
2. >New Transaction >Payment
3. Payment Method: Cash or some other (refer to similar transactions in the past).
4. Deposit to: either bank account where the payment was deposited, or if cash, to Undeposited Funds (for Deposit later to Cash on Hand).
5. Select or more Invoices to be paid. To reach the correct Amount received (on the upper right), modify the amounts on the PAYMENT column to the right.
6. Save and Send.
7. NOTE: in cases where the payment amount is lower than the selected invoice amount, the difference will just appear next time a Payment is made.
8. NOTE: in cases where the payment amount is over the selected invoice amount, there will be an “Amount to Credit” on the lower right. This is the difference, and will be available for future payments (along with any Journals that might have been made – e.g., funds from an agency assigned to the student using a Journal).

1. Issue a Sales Receipt to the Donor as usual (see above).
2. NOTE: In QB, a “Journal” refers to the reassigning of amounts by Debiting an account (e.g., RCAM) and Crediting it to another (e.g., student from Manila) – even though in Accounting, a Journal is a record of any transaction.
3. Creating a Journal makes funds available to pay Invoices. This amount is seen via >New Transactions >Payment, then see Credits at the bottom.
4. >+New >Journal
5. Check that the automatic Journal no. is in the correct series (year-3 digits).
6. For example, for Santa Croce, Debit 4500000 PASS-THROUGH INCOME, with >Name (rightmost column) Pontificia Università della Santa Croce; and Credit 1200000 ACCOUNTS RECEIVABLES, with >Name (rightmost column) of student.
7. For RCAM, Debit 2201000 NON-CURRENT LIABILITIES: ROMAN CATHOLIC ARCHBISHOP OF MANILA, with >Name (rightmost column) Roman Catholic Archbishop of Manila; and Credit 1200000 ACCOUNTS RECEIVABLES, with >Name (rightmost column) of Manila student.
8. Substitute RCAM to Debit any other funding agency, and put corresponding student name(s) to Credit. The Debit total should always equal the Credit total.
9. >Save and Close.

1. > scan bill, name it as usual (see other examples, especially for the same supplier)
2. > save it folder: Transactions for Encoding
3. > create QB Bill (see previous bills as examples), and attach the scan
4. > transfer the scan to the folder: Encoded not yet paid

1. > Rapporti
2. > Giroconto
3. > Per il Conto N. 11784003 – OPERAZIONI – EUR (€)
4. > Divisa: EUR
5. > Importo (expresso nella divisa di addebito): amount in digits; decimal point should be in comma, not period
6. > Causale: Giroconto Generico
7. > Descrizione Causale: (e.g., Allowance for January 2023)
8. > Beneficiario: (account holder)
9. > Numero Conto Beneficiario: (8-digit IOR account number)
10. > Inidrizzo Beneficiario: (address)
11. > Tipo Beneficiario: (e.g., Soggetto Collegato)
12. > Relazione con la controparte: (optional)
13. > File da allegare: (for bill payments, attach a single pdf file; leave blank for PCF OP Sisters and Admin allowances)
14. > Continua: this brings you to the next screen to double check information
15. > Continua: OTP appears on your smartphone, to be entered on the screen
16. > Dispositiva inviata con successo: this message confirms successful entry, which will be approved by an authorized user
    

1. > Rapport
2. > Bonifico
3. > Per il Conto N. 11784003 – OPERAZIONI – EUR (€)
4. > Divisa: EUR
5. > Importo (expresso nella divisa di addebito): amount in digits; decimal point should be in comma, not period
6. > Causale: Bonifico Generico
7. > Descrizione Causale: (e.g., Allowance for January 2023, or company name with fattura number and dates covered)
8. > Tipologia di Spesa: Spese a carico dell’ordinante.
9. > Beneficiario: (account holder)
10. > Inidrizzo Beneficiario: (address)
11. > Tipo Beneficiario: Stesso Cliente (if transfer to another PCF account), Soggetto Collegato (if PCF Admin or Sisters) or Altro (for suppliers, universities, etc.)
12. > Relazione con la controparte: fornitore
13. > IBAN/Conto Beneficiario: (put IBAN)
14. > **Bic/Swift: (instead of IBAN if no IBAN)
15. > **Codice Destinatario Fedwire/Routing Number: (instead of IBAN if no IBAN)
16. > Codice Intermediario Fedwire/Routing Number: (disregard if IBAN is used)
17. > Bic banca intermediaria: (disregard if IBAN is used)
18. > File da allegare: (only a single pdf file may be attached, so multiple bills have to be combined first)
19. > Note: (optional)
20. > Continua: this brings you to the next screen to double check information
21. > Continua: OTP appears on your smartphone, to be entered on the screen
22. > Dispositiva inviata con successo: this message confirms successful entry, which will be approved by an authorized user

1. Using BancoPosta BPIOL’s Bonifici XML
   > Operazioni Veloci >Bonifici XML
   > Disposizione
   
   > [in upper box] Data Esecuzione (put current or future date)
   > Distinta (put “01”)
   
   > [in lower box] Importo (EUR): put the amount (make sure to use comma instead of period as decimal point)
   > Nome Creditore: put supplier’s name
   > IBAN Creditore: put supplier’s IBAN
   > CODICE CATEGORIA (ISO): put CASH (Generica Cash)
   > CAUSALE/INFORMAZ RICONCILIAZIONE: put reason for payment (e.g., 2023 January salary)
   
   > MEMORIZZA: at this point, the Bonifico is ready to be signed and sent by the authorized signer. (Use CREA FLUSSO if you are the authorized signer.)
   
   
2. Using Banco Posta’s BPIOL for Bollettini Postali
   > Operazioni Veloci >PAGAMENTO BOLLETTINI PRECOMPILATI
   > DISPOSIZIONE
   > sul C/C >N.: put C/C n. found in the bollettino
   > IMPORTO: put amount to be paid (make sure to use comma instead of period as decimal point)
   > CODICE A 18 CIFRE: put the 18 digits found in the bollettino
   > TIPOLOGIA: copy number at lower right of bollettino (usually “674”)
   > RAGIONE SOCIALE O NOME: “put Pontificio Collegio Filippino”
   > INDIRIZZO: put “Via Aurelia 490”
   > CAP: put “00165”
   > CITTÀ: put “Roma”
   > PROVINCIA: put “RM”
   > CONTINUA
   > MEMORIZZA: at this point, the Bonifico is ready to be signed and sent by the authorized signer.
   
3. Using Banco Posta’s BPIOL for PAGOPA
   > Operazioni Veloci >PAGOPA
   > Canale di Pagamento >Bollettino Postale PA
   > DISPOSIZIONE
   > CODICE AVVISO: copy the 18 digits
   > SUL C/C N.: copy from bollettino
   > CALCOLA IMPORTO: then the Importo, Pontificio Collegio Filippino and its Codice Fiscale should automatically appear
   > SALVA: at this point, the Bonifico is ready to be signed and sent by the authorized signer.
   
4. Using Banco Posta’s BPIOL for F24
   > Operazioni Veloci >F24 Online
   > DISPOSIZIONE
   > Tipo Delega: Modello F24 Ordinario
   > Vuoi eseguire il pagamento come: Persona Giuridica
   
   > CONTRIBUENTE: Codice Fiscale/Partita IVA: PCF’s Codice Fiscale automatically appears
   > DATI ANAGRAFICI: complete the fields as seen in the F24 received via email or mail
   > Sezione Errario or Sezione INPS (usually, depending on the F24 received): fill up the columns by copying exactly from the F24 received (make sure to use comma instead of period as decimal point); the total will be automatically computed
   > for the Sezione Erario, make sure the month is preceded by two zeros (for example, July would be “0007” – even if it is only “07” in the original). For the Sezione INPS, there is also an indication for the month and year.
   > CONTINUA, then a similar screen appears, this time to double check.
   > MEMORIZZA: at this point, the Bonifico is ready to be signed and sent by the authorized signer.

1. Return to the Supplier, look for the Bill previously prepared, click on Make Payment
2. > Bank/Credit Account: select the correct account
3. > indicate correct Payment Date
4. > the amount to be paid has been automatically ticked; this amount may be modified on the upper right “Amount” box, and if so, the Bill will be reduced to the amount lacking.
5. > PRINT, then make a screenshot (Shift-Win S), paste into MS Word A5, print >Printer Properties
6. > TAB Paper Options >Paper >A5
7. > TAB Image Options >Xerox Black and White Conversion
8. > OK >Print
9. Have the sheet signed by the one who received the funds; this sheet will be considered as the “receipt” in the next step
10. scan the receipt (or the signed sheet) and attach it to the Bill
11. transfer the fattura scan, receipt scan and/or the signed sheet to the computer folder and physical folder of each Supplier

1. +New > Journal entry
2. Account: select the bank or account where the amount was returned (e.g., IOR-03), Debit the amount returned, and no need(?) to put Name
3. Account: select the corresponding Expense account, Credit the amount returned, put Description, and put Name of who returned the amount
4. Note that if what was returned is less than the original expense (for example, if there were fees, or only a partial refund was made), the difference still remains as an expense.

1. +New > Credit note